What happened to Flash Fill in Excel?


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Back in Excel 2013, Flash Fill was added, a nifty way to join or separate a string from other cells by example.   If its seems to have disappeared from Excel 2016 for Windows, here’s how to get it back.

img 5a675fa8b20ca - What happened to Flash Fill in Excel?

In Excel 2013, Flash Fill worked automatically.  Just typing the first example in a neighboring cell was enough to trigger Flash Fill and it would show the proposed changes.

img 5a675fcd4936a - What happened to Flash Fill in Excel?

But it doesn’t always work that way in Excel 2016 for Windows.   Sometimes the suggestions will appear but other times it doesn’t.  We’re not sure why but you can make Flash Fill work even if the automatic system doesn’t.

Turn on Automatic Flash Fill

The first thing to check is that automatic Flash Fill is on.  Go to Options | Advanced | Editing options | Automatically Flash Fill.

what happened to flash fill in excel microsoft excel 16620 - What happened to Flash Fill in Excel?

If all else fails ….

If Flash Fill doesn’t pop up as you’d like, it’s just a click away from several places.

On the Data tab …

what happened to flash fill in excel microsoft excel 16621 - What happened to Flash Fill in Excel?

And under Home | Editing

what happened to flash fill in excel microsoft excel 16622 - What happened to Flash Fill in Excel?

subs profile e1563205311409 - What happened to Flash Fill in Excel?
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address