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!
Comments
Post a Comment