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).

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.

• Ctrl + N creates a new database.
• Ctrl + Tab goes to the next tab.
• Ctrl + 1, Ctrl + 2, etc. opens the recent file whose position in the list is the number used in the shortcut.
• Ctrl + F4 or Ctrl + Alt + W to close the database file (version 3.13).
• Ctrl + Shift + W or Ctrl + Shift + F4 to close the project (including the database file) (version 3.13).

These shortcuts work only for versions previous to 3.13:

• 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.

In v3.13, use the underscored accelerators for tab switching, and Ctrl + Alt + 0 for restoring the window layout (Ctrl + 0 since v3.13.2).

• Ctrl + R and F5 refresh the database structure.

• Ctrl + R and F5 refresh the currently browsed table.
• Ctrl + Space selects the entire columns of the currently selected cells.
• Shift + Space selects the entire rows of the currently selected cells.
• 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 (version 3.13).
• Ctrl + Alt + F (version 3.13.0 and 3.13.1) or F3 (since version 3.13.2) sets focus to the global filter line.

• Ctrl + R and F5 refresh the pragma values.

• 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.

• 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).

• Ctrl + Return clicks the OK button.