Keyboard Shortcuts
General
Undoing/Redoing
Hitting the keyboard shortcuts described below triggers undo/redo globally on any visible widgets,following the timeline in which the events occurred. This can be disabled by setting the flag enableHistoryKeyboardShortcuts
in the ActiveUIOptions
to false.
Key | Effect |
---|---|
Ctrl/Cmd + Z | Undo the previous action |
Ctrl/Cmd + Y | Redo the previous action |
Ctrl/Cmd + Shift + Z | Redo the previous action |
Exiting full-screen mode
This keyboard shortcut can be disabled by setting the flag enableFullSizeEscapeShortcut
in the ActiveUIOptions
to false.
key | Effect |
---|---|
Esc | Exit full-screen mode |
Tables and Pivot tables
Scrolling
Naturally, the mousewheel can be used to scroll up and down. Horizontal scrolling can be performed by holding Shift at the same time.
Selecting
Key | Effect |
---|---|
← ↑ → ↓ | Reduces the selection to one cell and moves it |
HOME | Moves the selection to the top cell of the same column |
END | Moves the selection to the bottom cell of the same column |
PAGE UP | Moves the selection up by the height of the table |
PAGE DOWN | Moves the selection down by the height of the table |
Holding Shift during these keyboard shortcuts allows you to extend the selection, instead of moving it.
Holding Ctrl/Cmd during these keyboard shortcuts lets you move the selection to the last cell in the desired direction, or extend it to the last cell if Shift is also held.
Holding Shift while clicking on a cell or drag and selecting a range of cells lets you extend your current selection to that cell or range of cells.
Holding Ctrl/Cmd while clicking on a cell or dragging and selecting a range of cells lets you add that cell or range of cells to your selection.
Copying
Key | Effect |
---|---|
Ctrl/Cmd + C | Copies the selected cells and their formatting |
Ctrl/Cmd + Shift + C | Copies the underlying values of the selected cells |
The Shift key can also modify the behavior of the Copy data to clipboard context menu item. By default it copies all captions of the table, but if you hold Shift while clicking it, it will instead copy the cells' underlying values.
Editors
key | Effect |
---|---|
Ctrl/Cmd + F | Performs search |
Ctrl/Cmd + H | Replaces next occurrence |
Ctrl/Cmd + Shift + H | Replaces all occurrences |
MDX Editor
Key | Effect |
---|---|
Ctrl/Cmd + I | Indents |
Ctrl/Cmd + SPACE | Auto-completes |
Ctrl + Enter | submits the query |
State Editor
key | Effect |
---|---|
Ctrl + Enter | Submit the state |
Popups
Key | Effect |
---|---|
Enter | Validate the popup, when there are no textareas inside the popup |
Ctrl + Enter | Validate the popup, when there are textareas inside the popup |
Escape | Cancels the popup |