Skip to content

Octa

Keyboard Shortcuts

thorstenfoltz/octa

Keyboard Shortcuts¶

Every action below is remappable under Settings → Shortcuts. The bindings shown are the defaults shipped with Octa.

The Settings dialog flags conflicting bindings. If you rebind one action to a combo already used by another, both rows highlight and the Apply button explains the conflict. Resolve it (rebind one of them, or clear the binding on one) before applying.

File operations¶

Action	Default	Notes
New file	`Ctrl`+`N`	Open an empty scratch tab.
Open file	`Ctrl`+`O`	File picker (multi-select supported).
Save file	`Ctrl`+`S`	Write back to the original path.
Save file as…	`Ctrl`+`Shift`+`S`	New path + optional new format.
Export schema…	`F7`	Open the Schema Export dialog with all 7 targets. See Schema Export.
Reload file from disk	`Ctrl`+`R`	Discards unsaved changes after a confirmation.
Close current tab	`Ctrl`+`W`	Prompts when there are unsaved changes.
Reopen last closed tab	`Ctrl`+`Shift`+`T`	Walks back through the last 10 closed tabs.
Quit application	`Ctrl`+`Q`	Prompts when any tab has unsaved changes.

Tabs¶

Action	Default	Notes
Next tab	`Ctrl`+`Tab`	Wraps to first.
Previous tab	`Ctrl`+`Shift`+`Tab`	Wraps to last.
Rename tab	`Ctrl`+`Alt`+`T`	Display name only; the file path is unchanged. Also tab right-click.

Search¶

Action	Default	Notes
Focus search box	`Ctrl`+`F`	Filter the table in real time.
Toggle find & replace	`Ctrl`+`H`	Replace bar above the table.
Open column filter	`Ctrl`+`Shift`+`F`	Per-column value filter. See Column Filter.
Find duplicate rows…	`Ctrl`+`Shift`+`D`	Dedupe-key picker + Highlight / New-tab output. See Editing → Find duplicates.
Find near-duplicates…	`Ctrl`+`Shift`+`U`	Fuzzy duplicate clusters (typos, spacing, word order). See Find Near-Duplicates.
Multi-search panel	`F6`	Cross-tab + directory grep with a docked result list. See Multi-search.
Open Chart tab	`F5`	Open a new tab dedicated to plotting the active table. Same as Analyse → Chart.... See Chart.

Action	Default	Notes
Go to cell (focus nav input)	`Ctrl`+`G`	Status-bar field accepts `R5:C3`, row #, column name.
Jump to first row	`Ctrl`+`Shift`+`↑`
Jump to last row	`Ctrl`+`Shift`+`↓`
Jump to first column	`Ctrl`+`Shift`+`←`
Jump to last column	`Ctrl`+`Shift`+`→`
Scroll up one page	`Ctrl`+`PgUp`	Advances selection by one visible page; spreadsheet-style.
Scroll down one page	`Ctrl`+`PgDn`	Mirror of Scroll up one page in the other direction.
Add bookmark...	`Ctrl`+`Alt`+`B`	Names the current selection as a session bookmark.

Selection¶

Action	Default	Notes
Select all rows	`Ctrl`+`A`	Inactive when a text editor is focused (lets Ctrl+A select text).
Extend row selection up	`Ctrl`+`↑`
Extend row selection down	`Ctrl`+`↓`
Extend column selection left	`Ctrl`+`←`
Extend column selection right	`Ctrl`+`→`

Ctrl+click a cell toggles it in a disjoint multi-cell selection. Mark / Copy / Cut then operate on every selected cell, following the same precedence Ctrl+M uses from the keyboard.

Editing¶

Action	Default	Notes
Edit current cell	`F2`	Same as double-clicking.
Insert row below	`Ctrl`+`Shift`+`Enter`	New empty row.
Duplicate selected row(s)	`Ctrl`+`D`	Copies the selected row(s) immediately below.
Delete selected row(s)	`Ctrl`+`Shift`+`K`
Number format...	`Ctrl`+`Shift`+`N`	Per-column number formatting dialog.
Undo last change	`Ctrl`+`Z`	Covers cell edits, structural changes, marks.
Redo last undone change	`Ctrl`+`Y`

Clipboard¶

Action	Default	Notes
Copy selection	`Ctrl`+`C`	TSV format on the clipboard.
Cut selection	`Ctrl`+`X`	Copies, then clears the cells.
Paste	`Ctrl`+`V`	Splits on tabs + newlines.
Copy as Markdown table	`Ctrl`+`Shift`+`B`	GitHub-flavoured Markdown table of the selection.

Marking¶

Action	Default	Notes
Mark selection (default colour)	`Ctrl`+`M`	Colour is Settings → Table → Default mark colour.
Filter to marked	`Ctrl`+`Alt`+`M`	Keep only marked rows/columns; press again to clear.

Text-case¶

Action	Default	Notes
Uppercase selected cells	`Ctrl`+`Alt`+`U`	Also works on TextEdit selections (SQL editor, raw editor).
Lowercase selected cells	`Ctrl`+`Alt`+`L`

Zoom¶

Action	Default	Notes
Zoom in	`Ctrl`+`+`	5% increments; 25% to 500% range.
Zoom out	`Ctrl`+`-`
Reset zoom	`Ctrl`+`0`	Back to 100%.

View¶

Action	Default	Notes
Cycle view mode	`F4`	Walks Table → Raw → Markdown → … skipping modes not applicable to the current file.
Toggle read-only mode	`F8`	Session-only; not persisted.
Toggle SQL panel	`Ctrl`+`J`	Same as Analyse → SQL. See SQL panel.
Opens Chat Assistant	`Ctrl`+`Shift`+`A`
Auto-fit all columns	`Ctrl`+`Shift`+`W`	Same algorithm as double-clicking a column-header seam, applied to every column.
Compare selected tabs	`F9`	Requires exactly one tab to be Ctrl-clicked in the multi-selection set.

SQL panel¶

Action	Default	Notes
Export SQL result	`Ctrl`+`Shift`+`E`	Save the current SQL result to a file. No-op when no result yet.

Dialogs¶

Action	Default	Notes
Open documentation	`F1`	This documentation, in-app.
Open settings	`F3`
Show column value frequency	`Ctrl`+`Shift`+`I`	Top-N values + counts for the column of the selected cell. See Value Frequency.
Pivot / Unpivot...	`Ctrl`+`Shift`+`P`	See Pivot / Unpivot.
Transform column...	`Ctrl`+`Shift`+`R`	See Transform column.
Conditional formatting...	`Ctrl`+`Shift`+`L`	See Conditional formatting.
Conditional column...	`Ctrl`+`Shift`+`J`	If / else-if / else CASE column. See Transform column.
Anonymise columns...	`Ctrl`+`Shift`+`Y`	Mask / scramble sensitive columns. See Anonymise Columns.
Data validation...	`Ctrl`+`Shift`+`G`	See Data validation.
Sort by columns...	`Ctrl`+`Shift`+`O`	Multi-column sort.
Summary tab	`Ctrl`+`Shift`+`M`	See Summary.
Data quality report...	`Ctrl`+`Alt`+`Q`	See Data Quality Report.
Rename columns	`Ctrl`+`Alt`+`R`	Bulk column rename. See Rename Columns.
Fill missing values...	`Ctrl`+`Alt`+`I`	See Fill Missing Values.
Union tables...	`Ctrl`+`Alt`+`N`	Needs two open tabs. See Union Tables.
Detect outliers...	`Ctrl`+`Alt`+`O`	See Detect Outliers.
Detect PII...	`Ctrl`+`Alt`+`P`	See Detect PII.

All of these are rebindable in Settings → Shortcuts, which refuses to let two actions share the same combination.

Cheat-sheet (most-used)¶

If you only remember a handful:


`Ctrl`+`O`	Open
`Ctrl`+`S`	Save
`Ctrl`+`F`	Search
`Ctrl`+`Z` / `Y`	Undo / Redo
`F4`	Cycle view
`F8`	Read-only
`Ctrl`+`J`	SQL panel
`Ctrl`+`Shift`+`T`	Reopen closed tab
`Ctrl`+`Shift`+`W`	Fit all columns

See also¶

Settings → Shortcuts, the rebinding UI.
Table View for context on the navigation and selection shortcuts.
Editing for context on the editing shortcuts.