Forum Discussion
Excel 2016 Series fill not properly working
Hi, I have a similar problem just in my case the selection of prefill options is not even there. It always used to work but suddenly a couple of days ago ist started showing the quick data analysis instead. See attached screenshots.
This is what happens when I drag the corner:
And these are then my options:
If you had any idea how to fix it it would be greatly appreciated..
Make sure these options were selected
- This immediately solved my problem, thank you!
OMG you just saved me. My issue was paste option was not enabled. thank you so so muchVu_Tran
- The best answer i've found. Thank you.
Vu_Tran Thanks for the advice. It was all correct in the settings but eventually I found out that the different pre-fill options are not available when one uses filters (when some of the rows are hidden). So I guess it had nothing to do with the settings, just the fact that this is for some reason not possible with filters on..
- Many thanks for sharing back. It works now.
What do you mean by saying "filter"? I don't get the solution and still have problems with this issue. Please help me. adaso16
