This article spells out keyboard shortcuts and other accessibility features of Power View in Excel 2013.
There are two versions of Power View: Power View in Excel 2013 and Power View in SharePoint 2013. The shortcuts in this topic only apply to Power View in Excel 2013. Read about everything else you can do in Power View.
Read about Keyboard shortcuts in Excel.
Notes
Power View supports:
- Most third-party screen readers.
- High contrast.
In this article
Overall navigation (Power View in SharePoint)
This section details the keys for moving from the browser to Power View in SharePoint, moving around the different parts of Power View, and moving among the objects in the view. In general adding the Shift key reverses the progression through a series.
| Action |
Keyboard operation |
| Move the focus from the browser to Power View. |
Tab (Shift + Tab) |
| Within Power View, move the focus to the next Power View shell component (e.g., from the ribbon to the field list to the view or vice versa). |
Ctrl + F6 (Shift + Ctrl + F6) |
| In the view, move the focus to the next (or previous) report item. |
Tab (Shift + Tab) |
| Tabbing among items in the view also moves the focus from the outside of a report item, into the parts of the item (for example, the cells in a table, series in a chart, or one small multiple), then to the sort options, then to the popout button on report items that support it. |
Tab until the part that you want has focus, then press Enter or Spacebar. |
Navigation within the ribbon (Power View in SharePoint)
Ribbon tabs
The currently active ribbon tab gets the focus by default whenever the ribbon gets the focus.
| Action |
Keyboard operation |
| Move focus to the next tab on the ribbon (e.g., from the Home tab to the Page Layout tab). |
Right arrow |
| Move focus to the previous tab on the ribbon (e.g., from the Home tab to the File tab). |
Left arrow |
Ribbon tab contents
| Action |
Keyboard operation |
| Move focus to the first control on the current ribbon tab. |
Down arrow or Tab |
| Move focus from the controls on the ribbon tab to the tab itself. |
Up arrow |
Ribbon controls
| Action |
Keyboard operation |
| Move focus to the next control on the current ribbon tab. |
Right arrow or Tab |
| Move focus to the previous control on the current ribbon tab. |
Left arrow or Shift + Tab |
Ribbon groups
| Action |
Keyboard operation |
| Move focus to next (or previous) group of controls on the current ribbon tab. |
Ctrl + right arrow (Ctrl + left arrow) |
Note Navigating to a group of controls sets the focus on the first control of the group.
Ribbon key tips
The Ctrl + F8 key combination shows ribbon key tips, regardless of what component or control currently has the focus. Additionally, ribbon key tips are displayed automatically whenever the ribbon gets keyboard focus.
| Action |
Keyboard operation |
| Toggle ribbon key tips on and off. |
Ctrl + F8 |
Other ribbon navigation keys
| Action |
Keyboard operation |
| Perform the default action for the control group regardless of which control has focus. |
Enter |
| Perform the action of the control that has focus. |
Spacebar |
Navigation for views (Power View in SharePoint)
| Action |
Keyboard operation |
| Move focus to previous view |
Up arrow or Page Up |
| Move focus to next view |
Down arrow or Page Down |
| Move focus to first view |
Home |
| Move focus to last view |
End |
| New view |
Ctrl+M |
| Delete view (with focus in view panel) |
Del |
| Create duplicate view |
Ctrl+Shift+M |
| Reorder views: Move selected view up/down |
Ctrl+up/down arrow |
| Navigate/select view (with focus in view panel) |
Up/down arrows |
Field list navigation (Power View in SharePoint)
| Action |
Keyboard operation |
General |
|
| Navigate in/out of field list |
Ctrl+F6, Shift+Ctrl+F6 |
| Navigate between field list and field areas |
Tab, Shift+Tab |
Field list navigation (Power View in Excel and SharePoint)
| Action |
Keyboard operation |
Fields section of Field List |
|
| Move to previous/next table or field |
Up, down arrow |
| Move to first/last table or field |
Home, End |
| Expand/collapse a table |
Left, right arrow |
| Select/Clear a field selection |
Spacebar |
| Add all/remove all default fields of a table |
Spacebar |
| Show dropdown menu |
Shift+Enter |
Layout section of Field List |
|
| Move to previous/next field within field area |
Up, down arrows |
| Move selected field to previous/next position within layout section |
Ctrl+up arrow, Ctrl+down arrow |
| Remove field |
Shift+Enter |
Table and matrix navigation (Power View in Excel and SharePoint)
| Action |
Keyboard operation |
| Enter table or matrix |
Tab, then Enter |
| Resize a table or matrix |
Shift + Ctrl + arrow keys |
| Move focus up/down one cell (across all cells in all areas) |
Up/down arrow |
| Move focus left/right one cell (across all cells in all areas) |
Left/right arrow |
| Move focus and view to first cell in the current row (for each area of the matrix) |
Home |
| Moves focus and view to last cell in the current row (for each area of the matrix) |
End |
Chart navigation (Power View in Excel and SharePoint)
| Action |
Keyboard operation |
|
Select a chart in the view and cycle through the parts of the chart in this order:
- Chart plot
- Legend
- Sort by field
- Sort in ascending or descending order
- Filter
- Pop out
|
Tab |
|
When the chart plot part of the chart has focus, cycle through the data in the chart in this order:
- Chart plot
- One entire series of data points (data blocks for column or bar charts)
- Each data point in that series
- Another entire series of data points
- Each data point in that series
|
Right/left arrow |
|
When the chart plot part of the chart has focus, cycle through data in the chart in this order:
- Chart plot
- One entire series of data points at a time
|
Up/down arrow |
| Resize a chart |
Shift + Ctrl + arrow keys |
| Select or deselect a data point (single click) |
Spacebar or Enter |
| Scroll up to the next set of data points |
Page Up |
| Scroll down to the next set of data points |
Page Down |
| Scroll left to the next set of data points |
Ctrl + Page Up |
| Scroll right to the next set of data points |
Ctrl + Page Down |
| Move focus to first set of data points (vertical) |
Home |
| Moves focus to last set of data points (vertical) |
End |
| Moves focus to 1st set of data points (horizontal) |
Ctrl + Home |
| Moves focus to last set of data points (horizontal) |
Ctrl + End |
| Axis zoom-in* (25% at a time, center-aligned) |
Ctrl + up arrow or Ctrl + right arrow |
| Axis zoom-out |
Ctrl + down arrow or Ctrl + left arrow |
* Axis zooming is for a continuous axis (for example, year or date). You can change an axis to continuous in the ribbon. On the Chart Tools contextual tab, on the Layout tab, click Type, and then click Continuous.
