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)
This module introduces Power Query in Microsoft Excel, a powerful data connection, cleaning, and shaping technology that is a core part of the Microsoft modern analytics suite of business intelligence tools.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.