Forum Discussion
Autofill options are not appearing when I drag the cell
Hi,
I want to drag cells down the same row. However, when I do it, it only repeats the same one, even though I select different dates, for example when selecting 09/04/19 & 10/04/19 and dragging them down, all the cells would have 09/04/19. As I drag the cells, autofill options do not appear, instead, I get the option for "quick analysis". Please help.
I discovered that my problem was that my spreadsheet was filtered. Once I removed the filter, I was able to fill series as normal.
Thank you! This was driving me batty. Some sheets would show Autofill, some wouldn't. Now I know why! God bless you, fine fellow.
- FoxyBweaver73066 - you had the answer i needed! thank you!!
To (re)activate the paste options:
File > Options > Advanced > Show paste options button when content is pasted (turn this on)
Hope this helps.
- Salmanali's answer works.
If you don't want to display the Auto Fill Options button every time you drag the fill handle, just turn it off. Similarly, if the button does not show when you use the fill handle, you can turn it on. Go to File / Office button -> Options -> Advanced and find the Cut, copy and paste
Sebastian_Mora , even your dates actually texts, autofill shall appear as
Quick analysis if only you select entire range
Try to drag pressing right button, when you shall have menu as this after releasing the button
