Forum Discussion

Atom328's avatar
Atom328
Copper Contributor
May 11, 2020
Solved

Auto Fill/Flash Fill Feature not recognizing pattern.

I tried a simple pattern of increasing each digit in the same column and highlighted the numbers with the intended empty columns to fill. I selected" flash fill" from the data tools menu. I keep gett...
excel
Excel on Mac
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 11, 2020

    Atom328  well I've never used "Flash Fill" and also can't get it to work.  That said, what I do is highlight the number pattern you have then use the little box in the bottom right of the selection to drag it down to fill in using that pattern.

Patrick2788's avatar
Patrick2788
Silver Contributor
May 11, 2020

Atom328 

I think the feature you're looking for is Series Fill (via Fill Handle or Home | Editing | Fill | Series).  Flash Fill looks at the adjacent column.

Resources