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 sheet | Ctrl + Home |
Navigate to last cell of sheet | Ctrl + End |
Navigate to first cell of current column | Ctrl + ↑ |
Navigate to last cell of current column | Ctrl + ↓ |
Navigate to first cell of current row | Ctrl + ← or Home |
Navigate to last cell of current row | Ctrl + → or End |
Move cursor up one viewport | Ctrl + PgUp |
Move cursor down one viewport | Ctrl + PgDn |
Navigation (Multi-cell selection) | |
Navigate Up | Shift + Enter |
Navigate Down | Enter |
Navigation (Single-cell selection) | |
Enter Editor | Enter |
Editing | |
Close editor (without saving) | Esc |
Clipboard | |
Cut | Ctrl + X |
Copy | Ctrl + C |
Paste | Ctrl + V |
Selection | |
Select All | Ctrl + A |
Extend Selection Upwards | Shift + ↑ |
Extend Selection Rightwards | Shift + → |
Extend Selection Downwards | Shift + ↓ |
Extend Selection Leftwards | Shift + ← |
Manipulation | |
Undo | Ctrl + Z |
Redo | Ctrl + Y or Ctrl + Shift + Z |
Clear current cell selection | Backspace 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.