Keyboard shortcuts in Power Query Online

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