Full List of 41 Power Query Keyboard Shortcuts You Need To Know About
Sep 23, 2023
I hate using my mouse.
A lot of people focus on shortcuts in Excel, with good reason.
A smaller number look at shortcuts in the Power BI front end.
This is a comprehensive list of 41 Power Query keyboard shortcuts to help you quickly navigate the back end.
The only way to get better at using your keyboard for these shortcuts is using your keyboard for these shortcuts.
Ban yourself from using your mouse.
If you do that, you'll end up saving hours over time.
Basic Navigation
-
Ctrl + N: Create a new query.
-
Ctrl + O: Open an existing query.
-
Ctrl + S: Save the current query.
-
Ctrl + C: Copy selected query elements.
-
Ctrl + X: Cut selected query elements.
-
Ctrl + V: Paste copied or cut query elements.
-
Ctrl + Z: Undo the last action.
-
Ctrl + Y: Redo the last undone action.
-
Tab: Move forward through the Power Query user interface elements.
-
Shift + Tab: Move backward through the Power Query user interface elements.
Query Editing
-
F2: Edit the selected cell.
-
Enter: Confirm changes in the cell.
-
Esc: Cancel editing or close the formula bar.
-
Ctrl + Enter: Apply changes and keep the cell selected.
-
Ctrl + Shift + Enter: Create a new line in the formula bar.
-
Alt + Enter: Start a new line within a formula or expression.
-
Ctrl + Space: Select the entire column.
-
Shift + Space: Select the entire row.
-
Ctrl + A: Select all query elements in the current step.
-
Ctrl + Click: Select multiple non-adjacent elements.
-
Ctrl + Shift + Click: Select a range of elements.
-
Ctrl + D: Duplicate selected query elements.
-
Delete: Remove selected query elements.
-
Ctrl + F: Open the Find and Replace dialog.
Data Transformation
-
Ctrl + T: Create a table from the selected data.
-
Ctrl + Shift + T: Convert a table into a list.
-
Ctrl + Shift + F: Format table columns.
-
Ctrl + M: Merge queries.
-
Ctrl + F1: Expand or collapse the formula bar.
-
Ctrl + H: Show or hide the Query Dependencies view.
Query Execution
-
Ctrl + E: Execute the current query.
-
Ctrl + L: Load query results to a destination (e.g., Excel worksheet or Power BI).
Query Navigation
-
Ctrl + Up Arrow: Move to the previous step.
-
Ctrl + Down Arrow: Move to the next step.
-
Ctrl + Shift + Up Arrow: Move selected step(s) up.
-
Ctrl + Shift + Down Arrow: Move selected step(s) down.
Advanced Techniques
-
Alt + Shift + F: Add a custom formula or function.
-
Alt + D: Create a date calculation.
-
Alt + N: Create a numeric calculation.
-
Alt + S: Create a text calculation.
-
Alt + C: Create a conditional column.
Download My Free Guidebook
The 3-Step Plan for Getting Started With PowerBI
Learn the best way I've helped large and small companies adopt the best analytics tool you've ever seen. In this FREE guide, I'll show you my complete startup strategy for Power BI.
We hate SPAM. We will never sell your information, for any reason.
