Keyboard Controls

DataGridXL implements many of the keyboard controls as seen in Microsoft Excel and Google Sheets. Here's a reference:

Basic Navigation

Navigate Up
Navigate Right
or Tab
Navigate Down
Navigate Left
or Shift + Tab

Advanced Navigation

Navigate to first cell of sheetCtrl + Home
Navigate to last cell of sheetCtrl + End
Navigate to first cell of current columnCtrl +
Navigate to last cell of current columnCtrl +
Navigate to first cell of current rowCtrl +
or Home
Navigate to last cell of current rowCtrl +
or End
Move cursor up one viewportCtrl + PgUp
Move cursor down one viewportCtrl + PgDn

Navigation (Multi-cell selection)

Navigate UpShift + Enter
Navigate DownEnter

Navigation (Single-cell selection)

Enter EditorEnter

Editing

Close editor (without saving)Esc

Clipboard

CutCtrl + X
CopyCtrl + C
PasteCtrl + V

Selection

Select AllCtrl + A
Extend Selection UpwardsShift +
Extend Selection RightwardsShift +
Extend Selection DownwardsShift +
Extend Selection LeftwardsShift +

Manipulation

UndoCtrl + Z
RedoCtrl + Y
or Ctrl + Shift + Z
Clear current cell selectionBackspace
or Delete

That's all folks!

If you feel like any key controls are missing, please let us know! One more thing: on Apple devices, the Ctrl key is replaced by command.


Leave email to receive latest updates!