Keyboard shortcuts in Power Query

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.

Query Editor

Action Keyboard shortcut
Get Data Ctrl+Alt+D
Enter Data Ctrl+Alt+T
Add custom column Ctrl+Alt+C
Choose column Ctrl+K
Go to column Ctrl+G
Add column from examples Ctrl+E
Blank query Ctrl+M
Advanced editor Ctrl+Shift+M
Refresh Alt+F5
Search Alt+Q

Data Preview

Action Keyboard shortcut
Copy cells/rows/columns Ctrl+C
Select all cells Ctrl+A
Select column Ctrl+Space
When the focus is on the column header
Action Keyboard shortcut
Filter menu Alt+Down arrow key
Change column type menu Ctrl+Down arrow key
Move focus to column header on the left Ctrl+Left arrow key
Move focus to column header on the right Ctrl+Right arrow key
Select first column Home
Select last column End
When the focus is on the cell
Action Keyboard shortcut
Select first cell of the row Home
Select last cell of the row End
Select first cell of the column Alt+Home
Select last cell of the column Alt+End
Select first cell of the first row Ctrl+Home
Select last cell of the last row Ctrl+End
Select the cell one page up Page up
Select the cell one page down Page down

Editable Grid (Enter data/Blank table)

Action Keyboard shortcut
Copy cells/rows/columns Ctrl+C
Paste cells/rows/columns Ctrl+V
Save entered data Ctrl+Enter
Show suggestions (when available) Ctrl+Space

Multi-line text editor (Blank query/Advanced editor)

Action Keyboard shortcut
Toggle tab behavior Ctrl+M

Diagram View

Action Keyboard shortcut
Expand selected query Ctrl+Right arrow key
Collapse selected query Ctrl+Left arrow key
Move focus from query level to step level Alt+Down arrow key
Move focus from step level to query level Esc
Expand all queries Ctrl+Shift+Right arrow key
Collapse all queries Ctrl+Shift+Left arrow key
Insert new step using+button (after selected step) Ctrl+Alt+N
Highlight related queries Ctrl+Alt+R
Select all queries Ctrl+A
Copy queries Ctrl+C
Paste queries Ctrl+V

Queries pane

Action Keyboard shortcut
Select all queries Ctrl+A
Copy queries Ctrl+C
Paste queries Ctrl+V
Select multiple consecutive queries Ctrl+Up arrow key and Ctrl+Down arrow key