Docs
Getting Started
Working with Data
How Tos
Frameworks
How it's Made
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 + home | Navigate to first cell of sheet |
| ctrl + end | Navigate 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 + pgup | Move cursor up one viewport |
| ctrl + pgdn | Move cursor down one viewport |
Navigation (Multi-cell selection) | |
| shift + enter | Navigate Up |
| enter | Navigate Down |
Navigation (Single-cell selection) | |
| enter | Enter Editor |
Editing | |
| esc | Close editor (without saving) |
Clipboard | |
| ctrl + x | Cut |
| ctrl + c | Copy |
| ctrl + v | Paste |
Selection | |
| ctrl + a | Select All |
| shift + ↑ | Modify Selection Upwards |
| shift + → | Modify Selection Rightwards |
| shift + ↓ | Modify Selection Downwards |
| shift + ← | Modify Selection Leftwards |
Manipulation | |
| ctrl + z | Undo |
| 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!