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.
