Skip to main content

Global shortcuts

These shortcuts can be used anywhere in the Omni app.
ActionMacWindows
Open/close application searchcommand + /control + /

Workbook shortcuts

These shortcuts apply in workbooks.
ActionMacWindows
New workbook taboption + Talt + T
Save workbookcommand + Scontrol + S
Edit workbook (transition from View)command + Econtrol + E
Toggle between results table / chartoption + 1alt + 1
Toggle filters open / closedoption + 2alt + 2
Toggle SQL block open / closedoption + 3alt + 3
Toggle field picker open / closedoption + 4alt + 4
Toggle options config open / closedoption + 5alt + 5
Toggle inspector panel open / closedoption + 9alt + 9
Toggle chart to full screen modeoption + .alt + .
Toggle AI Query helperoption + command + 8alt + control + 8
Run querycommand + Returncontrol + Enter
Run query w/o cacheshift + command + Returnshift + control + Enter
Clear querycommand + Kcontrol + K
Clear field from queryshift + command + Kshift + control + K
Clear filters from queryoption + command + Kalt + control + K
Clear query and switch modelshift + option + command + Kshift + alt + control + K
Focus field searchoption + command + Falt + control + F
Duplicate tabcommand + Dcontrol + D
Next tabcommand + option + downcontrol + alt + down
Previous tabcommand + option + upcontrol + alt + up
First tabcommand + option + [control + alt + [
Last tabcommand + option + ]control + alt + ]
Rename current taboption + command + Ralt + control + R

Spreadsheet tabs shortcuts

These shortcuts apply when working with spreadsheet tabs in workbooks.
ActionMacWindows
Delete row or columncommand + -control + -
Insert row or columncommand + +control + +
Boldcommand + Bcontrol + B
Italiccommand + Icontrol + I
Underlinecommand + Ucontrol + U
Format as percentagecontrol + shift + 5control + shift + 5
Cycle formula referenceF4F4

SQL editor autocomplete shortcuts

These shortcuts apply when working in the SQL editor in a workbook.
ActionMacWindows
Trigger autocompletecontrol + spacecontrol + space
Accept suggestiontabtab
Accept suggestion or insert newlinereturnEnter
Close autocomplete popupescesc

Dashboard shortcuts

These shortcuts apply when viewing or editing a dashboard.
ActionMacWindows
Undo layout changecommand + Zcontrol + Z
Redo layout changeshift + command + Zshift + control + Z
Reset dashboard filterscommand + Kcontrol + K
Refresh dashboardcommand + Returncontrol + Enter
Refresh dashboard without cacheshift + command + Returnshift + control + Enter

Table shortcuts

These shortcuts apply when interacting with tables in workbooks and dashboard tiles. All gestures require the visualization to be in table view.

Selection

ActionMacWindows
Select all cellscommand + Acontrol + A
Copy selected cellscommand + Ccontrol + C
Clear selection (keyboard)escapeescape
Move focused cellarrow keysarrow keys
Extend selection from anchorshift + arrow keysshift + arrow keys
Select a cellclickclick
Select range from anchor to cellshift + clickshift + click
Add or remove cell from selectioncommand + clickcontrol + click
Select a rectangular regionclick and dragclick and drag
Select entire rowclick row numberclick row number
Extend selection through rowshift + click row numbershift + click row number
Add or remove row from selectioncommand + click row numbercontrol + click row number
Select entire columnclick column headerclick column header
Extend selection through columnshift + click column headershift + click column header
Add or remove column from selectioncommand + click column headercontrol + click column header
Clear selection (mouse)click outside tableclick outside table
When all cells are selected with command/control + A, column headers are included when copying.

Editing and interaction (workbooks only)

These shortcuts are only available in workbook tables. Dashboard tables are read-only.
ActionMacWindows
Edit calculation cell or expand cellenterenter
Edit a calculation celldouble-clickdouble-click
Open context menuright-clickright-click
Reorder columnsDrag column headerDrag column header
Column reordering is not available in pivot tables.

Calculation editing (workbooks only)

These shortcuts apply when editing a calculation in a workbook table.
ActionMacWindows
Save calculationenterenter
Cancel and exit editorescapeescape
Insert cell range referenceshift + click a cellshift + click a cell

Markdown editor shortcuts

These shortcuts are available when editing text tiles in a dashboard.
ActionMacWindows
Boldcommand + Bcontrol + B
Italiccommand + Icontrol + I
Blockquoteshift + command + .shift + control + .
Ordered listshift + command + 7shift + control + 7
Unordered listshift + command + 8shift + control + 8

Model IDE shortcuts

These shortcuts apply when viewing or editing files in the model IDE.
ActionMacWindows
Save filecommand + Scontrol + S
Find / searchoption + command + Falt + control + F
Toggle file list open / closedoption + 1alt + 1
Toggle model validation list open / closedoption + 9alt + 9
Fold all sections in a filecommand + K, command + 0control + K, control + 0
Unfold all sections in a filecommand + K, command + Jcontrol + K, control + J