Skip to content

DataGrid behavior

Keyboard Shortcuts

The results grid supports keyboard shortcuts for common actions when it has focus.

ActionWindows/LinuxmacOS
Jump to columnCtrl + Shift + O or Ctrl + F12Cmd + Shift + O or Cmd + F12
Save changesCtrl + SCmd + S
RefreshCtrl + RCmd + R
UndoCtrl + ZCmd + Z
RedoCtrl + Y or Ctrl + Shift + ZShift + Cmd + Z or Cmd + Y
Add rowCtrl + NCmd + N
Add row from the last cell (editable tables)TabTab
Select rowShift + SpaceShift + Space
Select columnCtrl + SpaceCtrl + Space
Duplicate selected cells/rowsCtrl + Shift + DShift + Cmd + D
Delete selected rowsCtrl + Backspace or Ctrl + DeleteCmd + Backspace or Cmd + Delete
CopyCtrl + C or Ctrl + InsertCmd + C
Cut (copies, then clears the editable cells)Ctrl + XCmd + X
Copy qualified table name (table tabs and the connections tree)Ctrl + Alt + CCmd + Option + C
Transpose rows and columnsCtrl + TCmd + T
Focus WHERE filterCtrl + Shift + FCmd + Shift + F
Quick searchCtrl + FCmd + F
Move cell focusAssign in Keyboard ShortcutsCtrl + H / J / K / L
Chart selected cellsCtrl + GCmd + G
Close detail gridEscEsc

The grid actions are listed in VS Code’s Keyboard Shortcuts editor, where you can change their keys. Open it with Ctrl + K, Ctrl + S (Cmd + K, Cmd + S on macOS) and search for “DBCode”. Each grid action appears as DBCode: Grid: followed by its name, for example DBCode: Grid: Save Changes.

By default, Ctrl + H / J / K / L move cell focus left, down, up and right on macOS. On Windows and Linux, assign your own keys to DBCode: Grid: Move Left, Move Down, Move Up and Move Right in Keyboard Shortcuts.

Jump to column opens a small popup listing every column in the grid. Type part of a column name to filter, use the arrow keys to move the highlight, and press Enter to scroll that column into view and focus it. Hidden columns appear dimmed in the list; picking one makes it visible again. Press Esc to close the popup without jumping.