10/25/2015

How to Use Flash Fill in Microsoft Excel 2016 / 2013

In Excel 2013 and 2016, when Excel identifies a pattern in your data, it automatically starts Flash Fill, which asks you, if you want to fill the data automatically, if your data has consistency.
For instance, like in this name list, instead of refilling the entire list manually, in Name column to correct the text case, Flash Fill will automatically recognize the pattern in other cells, suggest you, if you want to go with the following pattern. If you are OK with data, just hit the Enter key, and here you have a long list of yours, automatically corrected and filled.
You can also check, if the Flash Fill options is turned on by default or not. To do this, click the File Menu, and then click Options. Click the Advanced options from the left side pane, and under Editing options, make sure Automatically Flash Fill is checked.
You can also use Flash Fill, by dragging the fill handle with right mouse button. Release the right-click, then click Flash Fill from the list, and Excel will automatically try to recognize and fill the data, accordingly. Or you can use the keyboard shortcut to use Flash Fill. Fill in the first pattern, select the cells and then press Control+E key. Alternatively, you can select the cells, and then click Data tab, and then click Flash Fill.
So, this was all about using Microsoft Excel Flash Fill. If you like this video, then do share it with your friends. Subscribe to our channel for more upcoming videos. Thanks for watching, and take care!