Forum Discussion
Excel 2016 Series fill not properly working
hi, in excel 2016 when i try autofill in series the two numbers i enter to create a pattern keeps repeating.
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..
What do you mean by saying "filter"? I don't get the solution and still have problems with this issue. Please help me. adaso16