Forum Discussion
Excel 2016 Series fill not properly working
Make sure these options were selected
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
- Thank you!
adaso16Thanks for your suggestion because I was facing same problem but when i switched Filter then it works normally. Thank you
adaso16 After about a hour of trying different solution, your answer was spot on for me. Thanks so much for putting it out there.
Thank youadaso16 for your comment. You saved me a lot of time searching for a solution. It sure would be nice if Microsoft would add this "exception" to the fill handle instructions in their support.microsoft.com website.
