Forum Discussion
Issues with Auto Fill Options in Excel
The fact that the numbers are not filled in automatically may be due to the filter.
If sheet you are experiencing the issue on currently has a filter applied, you won't be able to use the Fill Series feature. It will only copy the top value down.
So in order to enable or re-enable autofill series or numbers by clicking on the bottom corner right of the cell and dragging it down/across, remove whatever filter there is at the top of its table.
Otherwise you might keep getting stuck with a Quick Analysis pop up option which wont help the autofill even if you remove it from options.
Important additional information:
How To Fix Excel Fill Handle Not Working Issue?
Standard Disclaimer: These are links to non-Microsoft websites.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
It never ceases to amaze me how microsoft makes their product worse as versions are released. This functionality was 100% available in previous releases.
- same here. I think that they are all on heavy drugs.
