Accessibility Features in Microsoft Power Query for Excel

Microsoft Power Query for Excel is dedicated to ensure that functionality is available to people with disabilities. In addition to incorporating accessibility features that are consistent with Microsoft Excel 2013, Power Query incorporates accessibility support for common scenarios and provides workarounds where possible.

In this article


Power Query incorporates accessibility support consistent with Windows 7 and Office 2013 applications.

Power Query ribbon

Office 2013 has applied the Fluent user interface, or the ribbon, to all Office applications, providing a consistent look across applications. With the POWER QUERY ribbon, you can perform various user actions.

Keyboard access to the ribbon

If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. The ribbon comes with shortcuts, called Key Tips. To make the Key Tips appear, press ALT.

Power Query Ribbon KeyTips

To display a tab on the ribbon, press the key for the tab. Press the letters Y2 for the POWER QUERY tab. The Key Tip badges for that tab's buttons appear. Then, press the key for the button you want. For example, press the letter F for the Online Search button.

Data Explorer Ribbon KeyTips 2

Additionally, to aid users who move through the ribbon by using their keyboard, it is now possible to jump from Group to Group by pressing Ctrl + Right/Left Arrow on a ribbon tab to move to the next/previous Group.

Top of Page Top of Page

Keyboard keys

There is no support for short-cut/hot-keys within the Power Query editor.

Search ribbon

On the POWER QUERY tab, press the letter F to display the Online Search pane.

Power Query Search Ribbon KeyTips

Search for a query

  1. Type a search term into the search box.
  2. Press Enter or press Tab to move focus to the Search button then press Spacebar.

Navigate search results

  • Press Tab to navigate into the search results list. Press Shift+Tab to navigate backwards.
  • To move to a search result page, press Tab until focus is on a result page button. Press Tab to select a result page and press the Spacebar.
  • To move to the next or previous search result page, Tab to Next or Prev and press Spacebar.
  • To return to a previous set of search results, tab to Back Back Arrow and press Enter or Spacebar.

Import a search result item

  1. Navigate to a search result item.
  2. Press Enter or Spacebar.

Top of Page Top of Page

Query Editor ribbon

With the Query Editor ribbon, you can perform data transformation tasks. In the Query Editor dialog box, press Y01 to reveal the Home tab keyboard keys or Y02 to reveal the View tab keyboard keys.

Query Editor Ribbon KeyTips

Home tab

Query Editor Ribbon KeyTips

Insert tab

Query Editor Ribbon KeyTips

View tab

Query Editor Ribbon KeyTips

Steps pane

Use the Up/Down Arrow keys to navigate between steps in your query.

Press F2 to rename the current step.   

Windows 7 High contrast

Power Query supports usage of the product while in a Windows 7 High Contrast mode. For more information about how to enable High Contrast in Windows 7, see Turn on High Contrast.

Top of Page Top of Page

Windows 7 Narrator

You can read content using Windows 7 Narrator. For more information about how to enable Narrator in Windows 7, see Turn on and use Narrator.

Top of Page Top of Page

Additional information and keyboard shortcuts

Use Windows to make your Office experience accessible

Keyboard shortcuts in Excel

Microsoft Accessibility site

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Excel 2010