Keyboard shortcuts

Abstract

This Wiki page aims at listing the more 'hidden' keyboard shortcuts. By this I mean those shortcuts that aren't obviously visible in the menus (e.g. Ctrl + N for a new database), that aren't simply Alt accelerators (e.g. Alt + E for clicking the button with the underlined E), and that aren't typical for all GUI application (e.g. Tab for changing focus).

Notes

Mac users have to press ⌘ instead of Ctrl

Note that for some key combinations where a symbol is used, you might need to add the Shift or the AltGr key to the combination if your keyboard layout requires it to enter the symbol.

For example, Ctrl+" is the shortcut for duplicating a row. However, some keyboard layouts need the Shift key pressed in order to trigger a ". For example in the Spanish (Spain) and British keyboard layouts, you'll need to actually press Ctrl+Shift+2.

Main window

Ctrl + N creates a new database.
Ctrl + Tab go to next tab.
Alt + 0 restores the window layout used by the application by default (version 3.12).
Alt + 1 switches to the 'Database Structure' tab.
Alt + 2 switches to the 'Browse Data' tab.
Alt + 3 switches to the 'Edit Pragmas' tab.
Alt + 4 switches to the 'Execute SQL' tab.
Ctrl + 1, Ctrl + 2, etc. opens the recent file whose position in the list is the number entered in the shorcut.
Ctrl + F4 or Ctrl + Alt + W to close the database file (future version 3.13).
Ctrl + Shift + W or Ctrl + Shift + F4 to close the project (including the database file) (future version 3.13).

Database Structure tab

Ctrl + R and F5 refresh the database structure.

Browse Data tab

Ctrl + R and F5 refresh the currently browsed table.
Ctrl + " duplicates the currently selected record.
Ctrl + ' copies the data from the cell above the current (version 3.11).
Ctrl + PageUp and Ctrl + PageDown switch the currently browsed table to the previous or the next table.
Delete and Backspace delete the content of the current cell(s), setting it to an empty string.
Alt + Delete and Alt + Backspace delete the content of the current cell(s), setting them to NULL.
Tab moves to the next cell when the table browser is focused. When being on the last cell, a new row is inserted automatically.
F2 enters the cell editor mode.
Ctrl + Shift + Left mouse button follows the "link", that means:
- If the column contains a foreign key, the referenced table is opened in a new data browser and the related row is filtered.
- Otherwise, the cell content is interpreted as a URL or local file name, and it's opened in the browser or the default application, respectively.
Ctrl + Shift + F sets focus to the filter line header (future version 3.13).
Ctrl + Alt + F sets focus to the global filter line (future version 3.13).

Edit Pragmas tab

Ctrl + R and F5 refresh the pragma list.

Execute SQL tab

Ctrl + Return executes the SQL commands.
Ctrl + R and F5 execute the SQL commands.
Shift + F5 executes the SQL commands on the current line only.
Ctrl + W closes the current SQL tab.

Edit dialog and edit pane

Ctrl + Return clicks the Apply button.
Insert toggles overwrite mode in both text editor and hex editor.
Ctrl + F Opens the Find dialog (version 3.12).
Ctrl + H Opens the Find/Replace dialog (version 3.12).

Edit Table dialog

Ctrl + Return clicks the OK button.

SQL, JSON and XML editors

Key	Command
`Down`	Move down one line
`Shift`+`Down`	Extend selection down one line
`Alt`+`Shift`+`Down`	Extend rectangular selection down one line
`Ctrl`+`Down`	Scroll view down one line
`Up`	Move up one line
`Shift`+`Up`	Extend selection up one line
`Alt`+`Shift`+`Up`	Extend rectangular selection up one line
`Ctrl`+`Up`	Scroll view up one line
`Ctrl`+`]`	Move down one paragraph
`Ctrl`+`Shift`+`]`	Extend selection down one paragraph
`Ctrl`+`[`	Move up one paragraph
`Ctrl`+`Shift`+`[`	Extend selection up one paragraph
`Left`	Move left one character
`Shift`+`Left`	Extend selection left one character
`Alt`+`Shift`+`Left`	Extend rectangular selection left one character
`Right`	Move right one character
`Shift`+`Right`	Extend selection right one character
`Alt`+`Shift`+`Right`	Extend rectangular selection right one character
`Ctrl`+`Left`	Move left one word
`Ctrl`+`Shift`+`Left`	Extend selection left one word
`Ctrl`+`Right`	Move right one word
`Ctrl`+`Shift`+`Right`	Extend selection right one word
`Ctrl`+`\`	Move right one word part
`Ctrl`+`Shift`+`\`	Extend selection right one word part
`Alt`+`Home`	Move to start of display line
`Home`	Move to first visible character in document line
`Shift`+`Home`	Extend selection to first visible character in document line
`Alt`+`Shift`+`Home`	Extend rectangular selection to first visible character in document line
`End`	Move to end of document line
`Shift`+`End`	Extend selection to end of document line
`Alt`+`Shift`+`End`	Extend rectangular selection to end of document line
`Alt`+`End`	Move to end of display line
`Ctrl`+`Home`	Move to start of document
`Ctrl`+`Shift`+`Home`	Extend selection to start of document
`Ctrl`+`End`	Move to end of document
`Ctrl`+`Shift`+`End`	Extend selection to end of document
`PgUp`	Move up one page
`Shift`+`PgUp`	Extend selection up one page
`Alt`+`Shift`+`PgUp`	Extend rectangular selection up one page
`PgDown`	Move down one page
`Shift`+`PgDown`	Extend selection down one page
`Alt`+`Shift`+`PgDown`	Extend rectangular selection down one page
`Del`	Delete current character
`Backspace`	Delete previous character
`Ctrl`+`Backspace`	Delete word to left
`Ctrl`+`Del`	Delete word to right
`Ctrl`+`Shift`+`Backspace`	Delete line to left
`Ctrl`+`Shift`+`Del`	Delete line to right
`Ctrl`+`Shift`+`L`	Delete current line
`Ctrl`+`L`	Cut current line
`Ctrl`+`Shift`+`T`	Copy current line (before future v3.13)
`Ctrl`+`Shift`+`Insert`	Copy current line (after future v3.13)
`Ctrl`+`Shift`+`T`	Open SQL file in new tab (before future v3.13)
`Ctrl`+`T`	Transpose current and previous lines
`Ctrl`+`A`	Select all
`Ctrl`+`D`	Duplicate selection
`Ctrl`+`U`	Convert selection to lower case
`Ctrl`+`Shift`+`U`	Convert selection to upper case
`Ctrl`+`X`	Cut selection
`Ctrl`+`C`	Copy selection
`Ctrl`+`V`	Paste
`Ins`	Toggle insert/overtype
`Return`	Insert newline
`Tab`	Indent one level
`Shift`+`Tab`	De-indent one level
`Esc`	Cancel
`Ctrl`+`Z`	Undo last command
`Ctrl`+`Y`	Redo last command
`Ctrl`+`+`	Zoom in
`Ctrl`+`-`	Zoom out
`Ctrl` + `F`	Open the Find dialog (version 3.12) or the search bar in the Execute SQL editors
`Ctrl` + `H`	Open the Find/Replace dialog