Edit

Share via


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.

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