Keyboard shortcuts

This table lists the element tree keyboard shortcuts and their corresponding descriptions:

Key	Description
Ctrl + mouse click	Changes the selected state of the element, but it does not change the checked state.
Shift + mouse click	Creates a continuous selection from the elements that were selected.
Ctrl + Shift + mouse click	Extends the selection.
Esc	Deselects all elements.
Left arrow	Collapses the expanded parent element.
Right arrow	Expands the expandable element.
Down arrow	Navigates down.
Up arrow	Navigates up.
Space bar	Selects or clears elements.
Shift + arrow keys	Holding shift and using arrow keys extends or inverts selection.
Shift + Space bar	You can use mouse or arrow keys + Shift to select multiple elements.
Ctrl + A	Selects all visible elements.
Ctrl + Enter	Multiple writeback on contiguous cells. This shortcut works only for writeback-enabled formulas.
Ctrl + Alt + Shift + F9	Recalculates a report when manual calculation is selected in the Microsoft Excel toolbar.

This table lists the ribbon icons keyboard shortcuts and their corresponding descriptions:

Key	Description
Shift+Alt+A	Adds Ad-hoc report.
Shift+Alt+S	Adds Self-Service report.
Shift+Alt+H	Inserts horizontal elements.
Shift+Alt+V	Inserts vertical elements.
Shift+Alt+F	Inserts filters.
Shift+Alt+U	Inserts value.
Shift+Alt+E	Edits element.
Shift+Alt+B	Enables writeback.
Shift+Alt+W	Recalculate workbook.
Shift+Alt+R	Recalculate sheet.
Shift+Alt+D	Recalculate selected formulas.
Shift+Alt+P	Shows or hides task pane.
Shift+Alt+L	Logs in.
Shift+Alt+O	Logs out.
Ctrl+Alt+T	Transposes axis.
Ctrl+Alt+R	Moves hierarchy to rows.
Ctrl+Alt+C	Moves hierarchy to columns.
Ctrl+Alt+F	Moves hierarchy to filters.
Ctrl+Alt+K	Keeps selection.
CTRL+Alt+Z	Zooms in.
CTRL+Alt+Y	Zooms out.
CTRL+Alt+Down Arrow	Expands selected elements.
CTRL+Alt+Up Arrow	Collapses selected elements.
Ctrl+Alt+E	Converts slice to a cell.