In Excel for Microsoft 365 on Windows, press Ctrl+Alt+F5 to refresh all workbook data connections, including Power Query queries; press Alt+F5 to refresh the selected connection. To edit a query, use Data > Get Data > Launch Power Query Editor, or right-click an existing query in the Queries & Connections pane and choose Edit.
The most useful Power Query shortcuts
Power Query does not have one keyboard shortcut that opens the editor from anywhere in Excel. The quickest dependable keyboard commands are mainly for refreshing data and for common editing actions. Use the command that matches what you intend to update: refreshing one connection is different from refreshing every connection in the workbook.
- Alt+F5: Refresh the selected connection. If the query is loaded to a worksheet table, select a cell in that table first.
- Ctrl+Alt+F5: Refresh all data connections in the workbook. This can take longer than refreshing a single query, especially if several sources are slow.
- Ctrl+Z and Ctrl+Y: Undo and redo supported actions in the Power Query Editor. These apply to editing the query, not to undoing a completed refresh of worksheet data.
- Ctrl+C, Ctrl+X, and Ctrl+V: Copy, cut, and paste selected content where the editor supports those actions, such as in text fields or the formula bar.
Keyboard behavior can depend on which part of Excel has focus. For example, a refresh command issued while a worksheet is active may behave differently from a command used while a dialog or the editor is active. If a shortcut does not do what you expect, click the relevant query output or use the visible command on the Data tab.
What Power Query does in Excel
Power Query is Excel’s data-import and transformation tool, also called Get & Transform. It connects to sources such as workbooks, text files, folders, databases, and some online services, then records a sequence of steps for cleaning and shaping the data. Examples include removing columns, filtering rows, changing data types, splitting a column, and combining files.
Those recorded steps form a query. When you refresh it, Power Query reruns the steps against the source data and loads the result to a worksheet table or, where supported, to the workbook’s data model. This is why a refresh shortcut can save time: it repeats a prepared process instead of requiring you to clean a new export manually. It does not mean that every source refreshes instantly or that changes to the source are automatically reflected before a refresh.
A useful distinction is that editing a query changes its instructions, while refreshing runs those instructions. If a query produces the wrong columns, for instance, editing the transformation may be necessary. If the steps are correct but the source has changed, refreshing may be all that is needed.
Opening the editor and finding a query
On Excel for Microsoft 365 for Windows, open the editor from the ribbon with Data > Get Data > Launch Power Query Editor. The command is useful when you want to inspect or manage queries without first selecting an output table. Ribbon labels and available commands can vary slightly with updates and the width of the Excel window, so the Get Data menu is the reliable place to look.
For a query already in the workbook, open the query list from Data > Queries & Connections. In the pane, right-click the query and choose Edit. You can also double-click a query in the pane. This opens its steps in the Power Query Editor, where the Queries list lets you select other queries in the same workbook.
When adding a new source, use Data > Get Data and choose the appropriate source category or connector. Excel then guides you through selecting the source and, depending on the connector, previewing or transforming it. Not every connector is available in every Excel edition, operating system, or account configuration.
Refreshing one query or the whole workbook
Choose a targeted refresh when you know which output needs updating. Click a cell in the query’s loaded worksheet table and press Alt+F5, or use Data > Refresh All if you want to update every connection. The refresh command may also update other workbook connections, depending on how the workbook is set up. For that reason, Ctrl+Alt+F5 is not necessarily the best choice when you only need one small query refreshed.
Refresh can take longer than expected if the query reads a large file, combines many files, accesses a network location, or depends on another query. Excel may show a progress indicator or a message asking for credentials. Wait for the refresh to finish before editing or relying on the output; interrupting it can leave the displayed results out of date.
For recurring workbooks, check the query’s refresh settings in its connection properties rather than assuming a keyboard shortcut controls timing. Settings can include refreshing when the workbook opens or refreshing at an interval, where those options are available. A refresh setting does not eliminate the need to confirm that the source is reachable and that the latest output is correct.
Useful editor actions that are not special shortcuts
Many common Power Query tasks are easier to do from the ribbon or a column’s context menu than from a memorized shortcut. In the editor, selecting a column and using its header menu exposes operations such as removing, renaming, splitting, and changing the data type. The Home, Transform, and Add Column tabs group additional commands. A menu action typically creates a step that appears in Applied Steps.
For example, to remove blank rows, select a relevant column and use its filter menu to exclude blank values, or choose the applicable row-removal command on the Home tab. To change a date column that has been read as text, select the column and choose an appropriate type from the data type control. Review the preview after each operation: a conversion can fail or produce unexpected results if the source contains mixed formats.
When a command is used frequently, Excel’s ribbon Key Tips can help you navigate without a mouse. Press Alt in Windows to display the available letter prompts, then follow the letters shown on your screen. The prompts can vary with the ribbon layout and Excel version, so it is better to follow the visible prompts than rely on a fixed sequence copied from another installation.
How to choose the right refresh workflow
Before using a shortcut, decide whether you need to change the query, update the result, or both. These situations call for different actions:
- The source file has new rows: Refresh the relevant query, or use Refresh All if dependent queries and other connections also need updating.
- The output has an unwanted column: Edit the query and remove the column in its transformation steps, then refresh or load the revised result.
- A source path has changed: Edit the query’s source settings or update the source location, then confirm that the connection works.
- Several queries depend on one another: Refresh all when you need the workbook’s connected results brought up to date together. Check for errors in dependent queries if an upstream query fails.
Consider the size and importance of the workbook, too. A refresh-all command can affect more than the table currently on screen. In a workbook used for reporting, refresh at a suitable time and check the final row count, key totals, and any displayed error messages before sharing the results.
Common shortcut and refresh problems
If Alt+F5 appears to do nothing, first check that the active cell belongs to the query output you intend to refresh. The table may not be a Power Query result, or the workbook may be using a connection whose refresh is unavailable until credentials or a network connection are supplied. You can confirm the query exists in Data > Queries & Connections and try its context-menu refresh command.
If Ctrl+Alt+F5 starts a long refresh, that is expected when the workbook contains multiple connections or large queries. Avoid pressing the shortcut repeatedly; overlapping refresh attempts can make it harder to tell which operation has finished. Check Excel’s status or the query pane, and inspect error details if the refresh reports a failure.
If the refreshed table still looks old, confirm the query’s source path and the location of the file you edited. A query can point to a different copy of a workbook than the one you just changed. Also check whether the transformation filters out the new rows, whether the output is loaded where you expect, and whether another query depends on it.
Shortcuts can also be intercepted by a laptop’s function-key settings or another application. Some keyboards require holding Fn for function-key combinations. If a key command is unavailable or behaves differently, use the matching ribbon or query context-menu command instead.
Windows, Mac, and Excel for the web
The instructions above are for Excel for Microsoft 365 on Windows. On a Mac, Power Query availability and editing capabilities can differ by Excel version and connector. Use the Data tab and the query or connection controls available in your installation rather than assuming a Windows ribbon path is identical. The Mac keyboard uses different modifier keys for many Excel commands, and refresh shortcuts may not match the Windows combinations described here. The dependable fallback is the visible Data > Refresh All command, where available.
Excel for the web has a different interface and does not provide the same Windows desktop editor experience in every configuration. Depending on the workbook, account, and current feature availability, you may be able to refresh data or view query-related controls without having all desktop authoring features. If you need to create or substantially edit a query and the web interface does not offer the required command, open the workbook in the Excel desktop application.
Shortcuts can also differ among Excel releases and keyboard layouts. The Alt key-tip method is helpful on Windows because it displays the commands available in the current ribbon. On Mac or the web, using the visible menu is usually clearer than translating a Windows shortcut by guesswork.
Frequently Asked Questions
What is the Excel shortcut to refresh Power Query?
On Windows, use Alt+F5 to refresh the selected connection, typically with a cell in its loaded table selected. Use Ctrl+Alt+F5 to refresh all workbook data connections.
Is there a keyboard shortcut to open Power Query Editor?
There is no single universal shortcut to open the editor in Excel for Microsoft 365 on Windows. Use Data > Get Data > Launch Power Query Editor, or right-click a query in the Queries & Connections pane and choose Edit.
Does Ctrl+Alt+F5 refresh only Power Query?
No. It refreshes all data connections in the workbook, not just Power Query. If you only need one loaded query updated, select its output table and use Alt+F5, or choose the query’s refresh command.
Can I undo a Power Query refresh with Ctrl+Z?
Ctrl+Z can undo supported editing actions in the Power Query Editor, but it is not a reliable way to reverse a refresh and restore the previous loaded data. If the result matters, save a copy of the workbook before making major query or source changes.
Do Power Query shortcuts work the same on Mac?
No. Keyboard commands and feature availability differ between Windows and Mac, and can also vary by Excel version. On Mac, use the Data tab’s visible refresh and query commands if the Windows shortcut does not apply.
Related
- Uniform Inventory Spreadsheet: Build a Useful Tracker
- Excel Power Query for Data Cleaning: A Practical Guide
- Uni Budget Spreadsheet: Build a Student Budget in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Split Cell Into First and Last Name: A Clear GuideTo split a full name in Excel, select the name cells and use Data > Text to Columns…
- Human Body in Excel: Create a Diagram Step by StepTo create a simple human body diagram in Excel, use Insert > Shapes to combine an oval for…
- Can You Group Rows in Excel for Sorting? Here’s HowYes—but Excel’s Group command does not make rows stay together when you sort. To keep related records together,…
- Schedule Email in Outlook: Choose a Send Time on Any DeviceYes. In new Outlook or Outlook on the web, compose your message, select the arrow beside Send, choose…
- How to Find the Highest Number in ExcelIf your numbers are in A2:A6, enter =MAX(A2:A6) in an empty cell to return the largest one. For…
- Excel MAX Between Dates: Find the Highest Value in a RangeTo find the largest value recorded between two dates in Excel, use MAXIFS with the value range and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.