What happened to Flash Fill in Excel?

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.

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.

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.

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.

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 …

And under Home | Editing

Want More?

Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.