This is the demonstration file to accompany the article, How to create and populate a table in Microsoft Excel’s Power Query by Susan Harkins.

If you prefer using Microsoft Excel keyboard shortcuts, press Ctrl+E. When you run Flash Fill, Excel looks for patterns in the data, and tries to apply them to the remaining data in the range.

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...