Keyboard shortcuts in Power Query

 Query Editor

QUERY EDITOR
ActionKeyboard shortcut
Go to columnCtrl+G
Add column from examplesCtrl+E

Data Preview

DATA PREVIEW
ActionKeyboard shortcut
Copy cells/rows/columnsCtrl+C
Select all cellsCtrl+A
Select columnCtrl+Space
When the focus is on the column header
WHEN THE FOCUS IS ON THE COLUMN HEADER
ActionKeyboard shortcut
Filter menuAlt+Down arrow key
Change column type menuCtrl+Down arrow key
Move focus to column header on the leftCtrl+Left arrow key
Move focus to column header on the rightCtrl+Right arrow key
Select first columnHome
Select last columnEnd
When the focus is on the cell
WHEN THE FOCUS IS ON THE CELL
ActionKeyboard shortcut
Select first cell of the rowHome
Select last cell of the rowEnd
Select first cell of the columnAlt+Home
Select last cell of the columnAlt+End
Select first cell of the first rowCtrl+Home
Select last cell of the last rowCtrl+End
Select the cell one page upPage up
Select the cell one page downPage down

Editable Grid (Enter data/Blank table)

EDITABLE GRID (ENTER DATA/BLANK TABLE)
ActionKeyboard shortcut
Copy cells/rows/columnsCtrl+C
Paste cells/rows/columnsCtrl+V
Save entered dataCtrl+Enter
Show suggestions (when available)Ctrl+Space

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

MULTI-LINE TEXT EDITOR (BLANK QUERY/ADVANCED EDITOR)
ActionKeyboard shortcut
Toggle tab behaviorCtrl+M

Diagram View

DIAGRAM VIEW
ActionKeyboard shortcut
Expand selected queryCtrl+Right arrow key
Collapse selected queryCtrl+Left arrow key
Move focus from query level to step levelAlt+Down arrow key
Move focus from step level to query levelEsc
Expand all queriesCtrl+Shift+Right arrow key
Collapse all queriesCtrl+Shift+Left arrow key
Insert new step using+button (after selected step)Ctrl+Alt+N
Highlight related queriesCtrl+Alt+R
Select all queriesCtrl+A
Copy queriesCtrl+C
Paste queriesCtrl+V

Queries pane

QUERIES PANE
ActionKeyboard shortcut
Select all queriesCtrl+A
Copy queriesCtrl+C
Paste queriesCtrl+V

Comments

Popular Posts

Failed to execute the package or element. Build errors were encountered

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS