Keyboard Shortcuts¶

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

Click Record on a row and press the combination you want. While Octa waits for that press the keys do nothing else, so recording Ctrl+S records it rather than saving the file. Esc stops recording.

Two actions can never share a combination. If the one you press is already taken, Octa names the action holding it and offers Take it over: the key moves to the action you are recording, and the previous owner is left unbound (it shows (none) and you can record a new key for it). Nothing is written until you click Apply, so Cancel still discards the whole lot.

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.
Save database changes as SQL…	(unbound)	Render a database tab's pending edits as a reviewable script instead of applying them. See Database Connections.
Save to database…	(unbound)	Write the open table into a live connection or a DuckDB / SQLite file. See Database Connections.
Export workbook…	(unbound)	Write several open tabs into one `.xlsx`, one sheet per tab. See Saving.
Open URL…	(unbound)	Open an `http(s)://` or cloud address as a file. See Cloud Storage.
Export schema…	`F7`	Open the Schema Export dialog with all ten 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.
Open table folder	(unbound)	Open a Delta / Iceberg / dataset directory as one table. See Supported Formats.

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.
Open multi-search panel	`F6`	Cross-tab + directory grep with a docked result list. See Multi-search.
Run inventory on expanded cloud connection	(unbound)	Lists the objects under the expanded cloud prefix as a table. See Cloud Inventory.

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.
Jump to next flagged cell	`F10`	Steps through validation violations and detected outliers.
Jump to previous flagged cell	`Shift`+`F10`	Same set, other direction. Both wrap and respect filters.

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.
Open chart tab	`F5`	Open a new tab dedicated to plotting the active table. Same as Analyse → Chart.... See Chart.
Toggle chat assistant panel	`Ctrl`+`Shift`+`A`	Same as Analyse → Assistant. See Chat Assistant.
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.
Run SQL on server	(unbound)	Runs the editor statement on the tab's database connection instead of local DuckDB. See Database Connections.

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.
Clean-up suggestions	(unbound)	Toggles the panel; opening it scans. See Clean-up Suggestions.
File internals...	(unbound)	Physical layout of the open file. See File Internals.
Compare with database or cloud...	(unbound)	See Compare with Database or Cloud.
Join key finder...	(unbound)	See Join Key Finder.
Join diagnostics...	(unbound)	See Join Diagnostics.
Harmonise schemas...	(unbound)	See Harmonise Schemas.
Toggle Ask (plain-language filter)	(unbound)	Retargets the search box at a question instead of a filter.
Drop duplicate rows...	`Ctrl`+`Shift`+`H`	See Drop Duplicate Rows.
Join tables	`Ctrl`+`Shift`+`Q`	Needs two open tabs. See Join Tables.
Partition by column	`Ctrl`+`Shift`+`Z`	Writes one file per group. See Partition by Column.
Time series...	(unbound)	Time buckets and rolling windows. See Time Series.
Batch convert...	(unbound)	See Batch Convert.
Schema drift...	(unbound)	See Schema Drift.
Report...	(unbound)	HTML profiling report. See Report.
Fuzzy join...	(unbound)	See Fuzzy Join.
Data drift...	(unbound)	How one dataset changed between two versions. See Data Drift.
Relationship map...	(unbound)	Which tables link to which, and on which columns. See Relationship Map.

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

An action listed as (unbound) ships with no default combination, because every Ctrl+Shift+letter is already taken (and Ctrl+Shift+C / X / V fire the clipboard on the table regardless). Assign one yourself if you use it often; the menu entry works either way.

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