Keyboard shortcuts
This topic lists the keyboard shortcuts that you can use to navigate in the element tree. It also explains the keyboard shortcut behavior in Excel Integration.
In Excel Integration, keyboard shortcuts for the element tree and ribbon icons are available.
Keyboard shortcuts for the element tree
| Key | Description |
|---|---|
| Ctrl + mouse click | Changes the selected state of an element, but does not change the checked state. |
| Shift + mouse click | Creates a continuous selection from the selected elements. |
| 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 the selection. |
| Shift + Space bar | You can use the 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 the manual calculation is selected in the Microsoft Excel toolbar. |
Keyboard shortcuts for the ribbon icons
| Key | Description |
|---|---|
| Shift+Alt+A | Adds an Ad-hoc report. |
| Shift+Alt+S | Adds a Self-Service report. |
| Shift+Alt+H | Inserts horizontal elements. |
| Shift+Alt+V | Inserts vertical elements. |
| Shift+Alt+F | Inserts filters. |
| Shift+Alt+U | Inserts a value. |
| Shift+Alt+E | Edits an element. |
| Shift+Alt+B | Enables writeback. |
| Shift+Alt+W | Recalculates a workbook. |
| Shift+Alt+R | Recalculates a sheet. |
| Shift+Alt+D | Recalculates selected formulas. |
| Shift+Alt+P | Shows or hides the task pane. |
| Shift+Alt+L | Signs in. |
| Shift+Alt+O | Signs out. |
| Ctrl+Alt+T | Transposes an axis. |
| Ctrl+Alt+R | Moves a hierarchy to rows. |
| Ctrl+Alt+C | Moves a hierarchy to columns. |
| Ctrl+Alt+F | Moves a hierarchy to filters. |
| Ctrl+Alt+K | Keeps the selection. |
| Ctrl+Alt+N | Clones theAd-hoc Report functionality. |
| 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 a slice to a cell. |