Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop.Â
This article spells out keyboard shortcuts and other accessibility features of Power View in SharePoint Server, a feature of the SQL Server 2012 Service Pack 1 (SP 1) Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013.
There are two versions of Power View: Power View in Excel 2013 and Power View in SharePoint 2013. The shortcuts in this topic apply to Power View in SharePoint 2013.Â
Notes:Â Power View supports:
-
Most third-party screen readers.
-
High contrast.
In this article
Overall navigation
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
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
|
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
|
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 |
|
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
|
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
|
Action |
Keyboard operation |
|---|---|
|
Select a chart in the view and cycle through the parts of the chart in this order:
|
Tab |
|
When the chart plot part of the chart has focus, cycle through the data in the chart in this order:
|
Right/left arrow |
|
When the chart plot part of the chart has focus, cycle through data in the chart in this order:
|
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.
