Apr 10 2019 02:45 PM
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.
Apr 10 2019 03:30 PM
@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
Dec 04 2020 02:15 AM
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
Dec 04 2020 10:51 PM
Jul 03 2021 01:47 PM
To (re)activate the paste options:
File > Options > Advanced > Show paste options button when content is pasted (turn this on)
Hope this helps.
Apr 28 2022 03:19 PM
Aug 02 2023 11:25 AM
I discovered that my problem was that my spreadsheet was filtered. Once I removed the filter, I was able to fill series as normal.