Flash Fill Keyboard Shortcut
Flash Fill is one of the most popular new features in Excel 2013/2016. It will fill in cells for you automatically based on a pattern. So if you have first names in column A, and last names in column B, you can quickly fill column C with first and last names, or last names and then first names with a comma in between. Just supply the pattern for Excel, and it will do the rest.
And there is a handy shortcut key for Flash Fill. Simply highlight the cells containing the pattern as well as the empty cells you would like filled, and then press Ctrl + E. It’s that easy! Excel will fill in the cells with Flash Fill.
To learn even more about Flash Fill and see it in action, click here:
You can find thousands more short-segment videos like this one at www.intellezy.com. Start your free trial today.