New to Kendo UI for Angular? Start a free 30-day trial
Keyboard Navigation
The keyboard navigation of the Spreadsheet is always available.
The Spreadsheet consists of standalone components that have their own keyboard navigation shortcuts. Once their wrapper is focused, their own keyboard shortcuts are applied.
Shortcuts applicable to the content of the Spreadsheet.
| SHORTCUT | DESCRIPTION |
|---|---|
Ctrl + Y | Repeats the last action if possible by using the Redo command. |
Ctrl + Z | Reverses the last action if possible by using the Undo command. |
The Spreadsheet supports the following selection shortcuts:
| SHORTCUT | DESCRIPTION |
|---|---|
Ctrl + A | Selects the whole worksheet. |
Shift + Arrow Keys | Selects a range of adjacent cells, rows or columns by extending the selection by one cell, row or column. |
Ctrl + Shift + End | In cell selection mode, extends the selection of cells to the last cell on the worksheet located in bottom-right corner. In the formula bar, selects all text in the formula bar from the cursor position to the end. |
Ctrl + Shift + Home | Extends the selection of cells to the beginning (the top-left cell) of the worksheet. In the formula bar, selects all text in the formula bar from the cursor position to the beginning of the input. |
The Spreadsheet supports the following navigation shortcuts:
| SHORTCUT | DESCRIPTION |
|---|---|
Arrow Keys | Move one cell up, down, right of left in the worksheet. |
Tab | In cell selection mode, moves one cell to the right in a worksheet. |
Page Down | Moves one screen down in a worksheet. |
Page Up | Moves one screen up in a worksheet. |
Home | In cell selection mode, moves to the beginning of a row in a worksheet. In a menu or submenu, selects the first command. |
Ctrl + Home | In cell selection mode, moves to the first cell (the top-left cell) on a worksheet. |
End | In cell selection mode, moves to the far right cell of the active row. |
Ctrl + End | In cell selection mode, moves to the last cell on a worksheet, in the lowest used row of the used column on the bottom-right. |
* All inner Spreadsheet components follow their own keyboard navigation behavior when focused.
The following example demonstrates how to use the focus methods to implement the Tab key navigation with in-cell editing.
Example
View Source
Change Theme:
