Written By Rick de Groot

Rick is the founder of BI Gorilla. He believes learning is one of life's greatest pleasures and shares his knowledge to help you improve your skills.

Are you tired of clicking through menus and wasting time while working with Power Query? Then you are here at the right place.

In this article, I teach you all the keyboard shortcuts you need to improve your productivity and work like a pro. You’ll learn shortcuts to navigate through your data, edit code, and work with the ribbon.

These shortcuts will save you time and make you more efficient when working with Power Query. So, let’s get started and learn how to use Power Query like a boss with keyboard shortcuts!

Table of contents

Keyboard Shortcuts

Data Navigation

You certainly look through your data when analyzing the results. Whether it’s to inspect a cell or to apply transformations to a selection. The below shortcuts help you in selecting the relevant cells, rows and columns.

Keyboard ShortcutsActions
Ctrl + HomeSelect the upper left cell within a table.
Ctrl + EndSelect the bottom right cell within a table.
HomeSelect the first cell of the current row.
EndSelect the last cell of the current row.
Alt + HomeSelect the first cell of the current column.
Alt + EndSelect the last cell of the current column.
Page UpMove selection up one page from current selection.
Page DownMove selection down one page from current selection.
Arrow KeysMove selection to adjacent cell.
Ctrl + GOpens ‘Go to Column’ menu and jumps to searched column.
Ctrl + ASelect All Columns and Rows.
Ctrl + SpaceSelect Current Column.

Next to these easy keyboard shortcuts, there are a few more difficult navigation shortcuts you can use.

Keyboard ShortcutsAction
1. Go to 1st column (press Home)
2. Press (opens preview pane)
Inspect Row Values as List
1. Press Ctrl + Space (select column)
2. Hold Shift + / (expand selection)
Select Adjacent Column(s)
1. Press Ctrl + Space (select column)
2. Hold Ctrl + / (highlight column)
3. Press Space (select highlighted column)
Select Non Adjacent Column(s)
Select Column then press F2Rename Column
Alt + Open Filter menu
Ctrl + Open Change Column Type Menu

Queries Pane

When working with your queries, you may find yourself in need of selecting, copying or pasting queries. You can easily perform those actions with the keyboard shortcuts below.

Keyboard ShortcutsActions
Ctrl + ASelect all queries.
Ctrl + CCopy queries
Ctrl + VPaste queries
Ctrl + -> Press EnterSelect multiple queries.

Applied Steps

The applied steps pane is where Power Query stores its transformation logic. To create, delete or modify these steps, you can make use of the below keyboard shortcuts

Keyboard ShortcutsActions
Ctrl + EAdd column from examples.
DelRemove selected Column(s).
Select Step + F2Rename Step.
Alt + BackspaceCopies code of last selected step into formula bar.
Also works when coming from other query

Ribbon Navigation

The Power Query Ribbon contains all its UI transformations. You can reach each of the Ribbon tabs and transformation buttons by using shortcuts. The below keyboard shortcuts open the different tabs.

Keyboard ShortcutsActions
Alt + FOpen File menu
Alt + HOpen Home Tab
Alt + TOpen Transform Tab
Alt + AOpen Add Column Tab
Alt + WOpen View Tab
Alt + Z1Open Tools Tab
Alt + E1Open Help Tab

After reaching one of these tabs, you can continue navigating to the relevant transformation. There are too many options to list here, but Power Query will visually indicate the keyboard shortcuts to reach each of them.


Some shortcuts are more generic and can be used to save or close files. But also to adjust the font size of your queries.

Keyboard ShortcutsActions
Alt + F4Closes the Power Query Editor
F12Save file as
Ctrl + SSave file
Ctrl + Shift + +Increase font size
Ctrl + Shift + Decrease font size
Ctrl + 0Restore font size (use regular 0, not on numpad)
Menu KeyOpens right-click menu, behavior depends on context

Quick Access Toolbar

Did you know Power Query has a Quick Access Toolbar? You can add your favourite actions to it so you can easily access them. This may just save you a few clicks compared to the Shortcuts to reach the ribbon (as in the previous step).

To add a new action to the Quick Access Toolbar (QAT), right-click an operation in the ribbon and then select Add to Quick Access Toolbar.

Let’s say you have 3 actions in your QAT. To access the first one, you can press ALT + 1. For the second, you press ALT + 2 and ALT + 3 for the third.

Some of my favourite actions, mentioned in my preferred order, are:

  1. Advanced Editor
  2. Add Custom Column
  3. Unpivot Columns
  4. Add Index Column
  5. Query Dependencies
  6. Start Diagnostics and Stop Diagnostics

Advanced Editor Shortcuts

Besides everything mentioned above, there are quite some shortcuts available for the advanced editor. Because the quantity is substantial, you can find this post on 38 keyboard shortcuts for the advanced editor.


In conclusion, mastering keyboard shortcuts can make a big difference in your productivity when working with Power Query. By using the shortcuts for data navigation, queries pane, applied steps, and ribbon navigation, you can save time and work more efficiently.

Additionally, general shortcuts such as saving, closing, and adjusting font size can also be useful. With these shortcuts, you can navigate and edit your data more quickly and easily.

So, go ahead and try out these shortcuts and experience the difference it makes in your workflow. Enjoy Power Query!

Share on:

Latest from my blog

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.