Below is a list of time saving keyboard shortcuts that you can use in Power Query, in both Excel and Power BI.
Watch the video to see me demonstrate how to use them, and download a PDF containing all shortcuts.
Download Power Query Shortcuts PDF
Enter your email address below to download the sample workbook.
More Keyboard Shortcuts
You may also like to get a copy of my eBook 239 Excel Keyboard Shortcuts
All of these shortcuts work in both Excel and Power BI Desktop, except the shortcut to open the Power Query editor from Excel.
When the Power Query editor is open in both Excel and Power BI Desktop, pressing Alt highlights the keys required to access items on the Ribbon.
Items can be added to the Quick Access Toolbar in Excel and the Power Query editor by right clicking the item on the Ribbon and then clicking on Add to Quick Access Toolbar
Hold Shift then use ← or → to select other columns.
Hold Ctrl then use ← or → to move to other columns.Press Space to select those other columns
Press ← to preview the row's data.
Use ↑ and ↓ to preview different rows.
Alt + ↓
Use ↓ ↑ Tab to move around the menu.
Space to select/deselect items. Enter to confirm selections.
Ctrl + ↓
This key is usually found on your keyboard underneath the rightmost Shift key.
The menu displayed is context sensitive - what you see depends on what you have selected.
Then ← ↑
Enter or Space to open the menu