Keyboard shortcuts provide a quick way to navigate and allow users to work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using the mouse. The table in this article lists all the shortcuts available in Power Query Online.
When using the Query Editor in Power Query Online, you can navigate to the Keyboard shortcuts button in the Help tab to view the list of keyboard shortcuts.
Note
These shortcuts have been tested with Microsoft Edge on Windows and macOS. While we try to provide support for all browsers, other browsers can make or implement their own shortcuts. Because we can't control how other browsers behave, we can't guarantee that all the shortcuts in this list work on all browsers.
Query Editor
| Action |
Windows Keyboard shortcut |
macOS keyboard shortcut |
| Get data |
Ctrl+Alt+D |
Control+Option+D |
| Enter data |
Ctrl+Alt+T |
Command+Option+T |
| Add custom column |
Ctrl+Alt+C |
Command+Option+C |
| Choose column |
Ctrl+K |
Command+K |
| Go to column |
Ctrl+G |
Command+G |
| Add column from examples |
Ctrl+E |
Command+E |
| Blank query |
Ctrl+M |
Fn+Command+M |
| Advanced editor |
Ctrl+Shift+M |
Command+Shift+M |
| Refresh |
Alt+F5 |
Option+F5 |
| Search |
Alt+Q |
Option+Q |
Data Preview
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Copy cells/rows/columns |
Ctrl+C |
Command+C |
| Select all cells |
Ctrl+A |
Command+A |
| Select column |
Ctrl+Space |
Control+Space |
When the focus is on the column header
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Filter menu |
Alt+Down arrow key |
Option+Down arrow key |
| Change column type menu |
Ctrl+Down arrow key |
Command+Down arrow key |
| Move focus to column header on the left |
Ctrl+Left arrow key |
Command+Left arrow key |
| Move focus to column header on the right |
Ctrl+Right arrow key |
Command+Right arrow key |
| Select first column |
Home |
Fn+Left arrow key |
| Select last column |
End |
Fn+Right arrow key |
When the focus is on the cell
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Select first cell of the row |
Home |
Fn+Left arrow key |
| Select last cell of the row |
End |
Fn+Right arrow key |
| Select first cell of the column |
Alt+Home |
Fn+Option+Left arrow key |
| Select last cell of the column |
Alt+End |
Fn+Option+Right arrow key |
| Select first cell of the first row |
Ctrl+Home |
Fn+Command+Left |
| Select last cell of the last row |
Ctrl+End |
Fn+Command+Right arrow key |
| Select the cell one page up |
Page up |
Fn+Up arrow key |
| Select the cell one page down |
Page down |
Fn+Down arrow key |
Editable grid (Enter data/Blank table)
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Copy cells/rows/columns |
Ctrl+C |
Command+C |
| Paste cells/rows/columns |
Ctrl+V |
Command+V |
| Save entered data |
Ctrl+Enter |
Command+Return |
| Show suggestions (when available) |
Ctrl+Space |
Ctrl+Space |
Multi-line text editor (Blank query/Advanced editor)
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Toggle tab behavior |
Ctrl+M |
Control+Shift+M |
Diagram view
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Expand selected query |
Ctrl+Right arrow key |
Command+Right arrow key |
| Collapse selected query |
Ctrl+Left arrow key |
Command+Left arrow key |
| Move focus from query level to step level |
Alt+Down arrow key |
Option+Down arrow key |
| Move focus from step level to query level |
Esc |
Esc |
| Expand all queries |
Ctrl+Shift+Right arrow key |
Command+Shift+Right arrow key |
| Collapse all queries |
Ctrl+Shift+Left arrow key |
Command+Shift+Left arrow key |
| Insert new step using+button (after selected step) |
Ctrl+Alt+N |
Command+Options+N |
| Highlight related queries |
Ctrl+Alt+R |
Command +Options+R |
| Select all queries |
Ctrl+A |
Command+A |
| Copy queries |
Ctrl+C |
Command+C |
| Paste queries |
Ctrl+V |
Command+V |
Queries pane
| Action |
Windows keyboard shortcut |
macOS keyboard shortcut |
| Select all queries |
Ctrl+A |
Command+A |
| Copy queries |
Ctrl+C |
Command+C |
| Paste queries |
Ctrl+V |
Command+V |
| Select multiple consecutive queries |
Ctrl+Up arrow key and Ctrl+Down arrow key |
Command+Up arrow key and Command+Down arrow key |