Keyboard shortcuts in Power Query
- Get link
- X
- Other Apps
Query Editor
Action | Keyboard shortcut |
---|---|
Go to column | Ctrl+G |
Add column from examples | Ctrl+E |
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 |
- Get link
- X
- Other Apps
Comments
Post a Comment
Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You