Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
We never share your email address with anyone - never have, never will. 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.
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.
Flash Fill in Excel. September 4, 2018September 2, 2018. By Jen Kuntz. Have you ever used Flash Fill? It came out in Office 2013 (as far as I can confirm) and I must say, there are a number of different instances where I’ve found this extremely useful in a pinch to pull data out of some cell that contains.
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 oncea week.
We never share your email address withanyone - never have, never will.Privacy Policy.