Share via

Excel Flash fill number sequence is NOT WORKING

Anonymous
2022-12-30T19:37:43+00:00

I don't know what's going on with excel; for some reason, the excel flash fill number sequence isn't working. The fill handle used to look like this and would make the numbers 1,2,3,4,5,

But now, when you drag the fill handle, it look like this and goes 1,1,1,1,1,1,1

I'm not sure what to do I've uninstalled and reinstalled Microsoft Office twice now. I've checked all the advanced settings and even contacted Microsoft support and still cannot get this resolved. 

Any help would be greatly appreciated.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-12-30T20:13:05+00:00

    Did you drag using the right mouse button? Dragging the left mouse button will indeed produce 1, 1, 1, ... - as it has always done.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-01-03T13:57:33+00:00

    Thanks for your reply but that's not correct, Dragging the left mouse button has not always produce 1, 1, 1

    0 comments
  3. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2023-01-03T15:00:37+00:00

    It does for me, unless I hold the Ctrl key down while doing it. Either way, you should still get the Fill options dialog, not the Flash Fill one. You'll get the Quick Analysis one (the one in your second image) if you then reselect the data.

    0 comments