• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

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

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member
  • Login

Power Query Keyboard Shortcuts to Save Time

You are here: Home / Power Query / Power Query Keyboard Shortcuts to Save Time
power query keyboard shortcuts
December 2, 2021 by Philip Treacy

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.
Please enter a valid email address.

Download Shortcuts


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 F12
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
Philip Treacy

Microsoft Power BI Community Super User Logo

AUTHOR Philip Treacy Co-Founder / Owner at My Online Training Hub

Systems Engineer with 30+ years working for companies like Credit Suisse and E.D.S. in roles as varied as Network & Server Support, Team Leader and Consultant Project Manager.

These days Philip does a lot of programming in VBA for Excel, as well as PHP, JavaScript and HTML/CSS for web development.

He's particularly keen on Power Query where he writes a lot of M code.

When not writing blog posts or programming for My Online Training Hub, Philip can be found answering questions on the Microsoft Power BI Community forums where he is a Super User.

More Shortcuts Posts

double click shortcuts thumbnail

Hidden Excel Double Click Shortcuts

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

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.

20 Pro Excel 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

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.
Excel Named Ranges

Excel Named Range Shortcut

This Excel Named Range shortcut using the exclamation mark will enable you to create a global name with local scope.

More Power Query Posts

get started with power query

Get Started with Power Query

10x Productivity with Excel Power Query in 3 easy steps. Get data > Transform Data > Load Data = HOURS Saved!

Power Query if Statements incl. Nested ifs, if or, if and

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 3 Ways

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

Remove Blank Rows and Columns from Tables in 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

Extracting Data from Nested 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

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

Power Query Keyboard Shortcuts to Save Time

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 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

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

Pivot an Unknown Number of Rows into 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.


Category: Power QueryTag: shortcuts
Previous Post:Toggle Top N with Slicers
Next Post:5 Excel SUM Function Tricks

Reader Interactions

Comments

  1. Sean

    October 1, 2022 at 7:11 am

    Alt-end does not work. It only takes me to the end of the current page and not the end of the whole table.

    Reply
    • Philip Treacy

      October 4, 2022 at 9:07 am

      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

    December 13, 2021 at 8:44 pm

    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

      December 14, 2021 at 1:07 am

      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 Cancel reply

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

Current ye@r *

Leave this field empty

Sidebar

More results...

Popular Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel Office Scripts
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate
  • Sponsor Our Newsletter

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.