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. |
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. |
| 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. |
Navigation in the table
| 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. |
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 |
|
| 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. |
Marking
| Action |
Default |
Notes |
| Mark selection (default colour) |
Ctrl+M |
Colour is Settings → Table → Default mark colour. |
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. |
| 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. |
Inspector / dialogs
| Action |
Default |
Notes |
| Open documentation |
F1 |
This documentation, in-app. |
| Open settings |
F3 |
|
| Open column inspector |
Ctrl+I |
Column-level metadata + type info for the active tab. |
| Show column value frequency |
Ctrl+Shift+I |
Top-N values + counts for the column of the selected cell. See Value Frequency. |
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