My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Power Query Keyboard Shortcuts to Save Time

You are here: Home / Power Query / Power Query Keyboard Shortcuts to Save Time
power query keyboard shortcuts
by

Below is a list of time saving keyboard shortcuts that you can use in Power Query, in both Excel and Power BI.

Watch the video to see me demonstrate how to use them, and download a PDF containing all shortcuts.

Watch the Video

Subscribe YouTube

Download Power Query Shortcuts PDF

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.

More Keyboard Shortcuts

239 Excel Keyboard Shortcuts ebook cover

You may also like to get a copy of my eBook 239 Excel Keyboard Shortcuts



All of these shortcuts work in both Excel and Power BI Desktop, except the shortcut to open the Power Query editor from Excel.

When the Power Query editor is open in both Excel and Power BI Desktop, pressing Alt highlights the keys required to access items on the Ribbon.

Items can be added to the Quick Access Toolbar in Excel and the Power Query editor by right clicking the item on the Ribbon and then clicking on Add to Quick Access Toolbar


General
Open Power Query Editor (Excel Only)
Alt A P N L
Open Power Query Editor (after adding icon to 1st position on QAT in Excel)
Alt 1
Close Power Query Editor
Alt F4
Increase Font Size
Ctrl + Shift + +
Decrease Font Size
Ctrl + Shift + -
Reset Font Size (don't use 0 on numeric keypad)
Ctrl + 0

Navigation
Move around table cells, move between columns, move between rows
↑ ↓ ← →
Jump to first column (stay in current row)
Home
Jump to last column (stay in current row)
End
Jump to first cell in first column
Ctrl + Home
Jump to last cell in last column
Ctrl + End
Jump to first cell in current column (with any cell in column already selected)
Alt + Home
Jump to last cell in current column (with any cell in column already selected)
Alt + End
Move up/down a page of data in the table
Pg Up Pg Dn
Go To Column
Ctrl + G then choose the column

Select Columns and Rows
Select current column
Ctrl + Space
Select Adjacent Columns
Ctrl + Space to select a column.

Hold Shift then use ← or → to select other columns.

Select Non-Adjacent Columns
Ctrl + Space to select a column.

Hold Ctrl then use ← or → to move to other columns.

Press Space to select those other columns
Select All Columns
Ctrl + A
Preview an Entire Row's Data
Navigate to leftmost column.

Press ← to preview the row's data.

Use ↑ and ↓ to preview different rows.


Modify Columns
Rename Column
Select the column then F2
Delete Column(s)
Select one or more columns then Del
Add Column By Example
Ctrl + E

Open Menus
Open Sort and Filter Column Menu
Select a column.

Alt + ↓

Use ↓ ↑ Tab to move around the menu.

Space to select/deselect items. Enter to confirm selections.

Change Column Type Menu
Select a column.

Ctrl + ↓

Right Click Menus

This key is usually found on your keyboard underneath the rightmost Shift key.

The menu displayed is context sensitive - what you see depends on what you have selected.

Table Options Menu
Navigate to top cell in first column using Ctrl + Home

Then ← ↑

Enter or Space to open the menu

Exit Menu or Step Back a Level in Multi-Level Menus
Esc
power query keyboard shortcuts

More Shortcuts Posts

double click shortcuts thumbnail
There are a load of hidden Excel double click shortcuts that will streamline the way you work in Excel and save loads of time
dax editor keyboard shortcuts
Keyboard shortcuts for the DAX editor in Power BI. Learning DAX is hard enough. Make your life easier by using these keyboard shortcuts.
Excel Keyboard Shortcuts Used by Pros. These aren't your average CTRL+C type shortcuts. These are shortcuts that take the average user years to learn.
ALT codes for symbols and characters
How to use keyboard ALT codes to insert ASCII and Unicode symbols and characters in Excel. Download the free workbook for your reference.
essential excel shortcuts
Excel keyboard shortcuts I use all the time to help me work quickly and efficiently. How many do you use?
Excel Named Ranges
This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.

More Power Query Posts

How to write Power Query if statements, including nested if, ‘if or’ and ‘if and’, which are easier to write than their Excel counterparts.
power query variables
Power Query Variables enable you to create parameters that can be used repeatedly and they’re easily updated as they’re stored in one place.
delete empty rows and columns using power query
Delete blank rows and columns from tables using Power Query. Even rows/columns with spaces, empty strings or non-printing whitespace
extracting data from lists and records in power query
Learn how to extract data from lists and records in Power Query, including examples where these data structures are nested inside each other.
combine files with different column names in power query
Learn how to load data into Power Query when the column names in your data don't match up. Sampe files to download.
power query keyboard shortcuts
Time saving keyboard shortcuts for Power Query that work in both Excel and Power BI. Download the free Shortcuts eBook
remove text between delimiters power query
Remove all occurrences of text between delimiters. There's no in-built Power Query function to do this, but this code does.
power query advanced editor tips
Tips for using the Power Query Advanced Editor in Excel and Power BI. Watch the video to see these tips in action
pivot unknown variable number of rows to columns
How do you pivot rows to columns when you don't know how many rows you're dealing with? It's not as easy as you may think.
try otherwise power query iferror
Using TRY..OTHERWISE in Power Query Replicates Excel's IFERROR So You Can Trap and Manage Errors In Your Queries.


Category: Tag:

Reader Interactions

Comments

    • Philip Treacy

      Hi Sean,

      You need to have a cell in the column already selected for this to work. Sorry, that should be clearer. I’ve amended the description in the table above.

      Regards

      Phil

      Reply

  2. Ben

    Hi Philip,
    Thank you for the info provided ref to shortcuts.
    I was wondering if you could share as well information on the following:

    1 Table containing 3 columns

    Col1 = Value
    Col2 = CreationDate
    Col3 = Order Type ( can be A or X or E)

    for each Order type I need to sum up the value based on creationDate minus 90 days( working days)

    I’ve been searching all over the internet and couldn’t find anything.
    Thank you in advance
    Ben

    Reply

    • Catalin Bombea

      Hi Ben,
      You can add a new column to calculate the date -90 days, then use the Group By option from the PQ Editor>Transform tab, make sure you group by Order Type and Date-90 column, use Sum as aggregation function for Values column.
      If you still can’t do it, please use our forum to upload a sample file, will help you solve it.
      Cheers,
      Catalin

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Current ye@r *