Keyboard Controls

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

* On Apple devices, ctrl is replaced by command.

Basic Navigation

Navigate Up
, tab
Navigate Right
Navigate Down
, shift + tab
Navigate Left

Advanced Navigation

ctrl + homeNavigate to first cell of sheet
ctrl + endNavigate to last cell of sheet
ctrl + Navigate to first cell of current column
ctrl + Navigate to last cell of current column
ctrl +
, home
Navigate to first cell of current row
ctrl +
, end
Navigate to last cell of current row
ctrl + pgupMove cursor up one viewport
ctrl + pgdnMove cursor down one viewport

Navigation (Multi-cell selection)

shift + enterNavigate Up
enterNavigate Down

Navigation (Single-cell selection)

enterEnter Editor

Editing

escClose editor (without saving)

Clipboard

ctrl + xCut
ctrl + cCopy
ctrl + vPaste

Selection

ctrl + aSelect All
shift + Modify Selection Upwards
shift + Modify Selection Rightwards
shift + Modify Selection Downwards
shift + Modify Selection Leftwards

Manipulation

ctrl + zUndo
ctrl + y
, ctrl + shift + z
Redo
delete
, backspace
Clear current cell selection

That's all folks!

If you feel like any key controls are missing, please let us know!

Leave email to receive latest updates!