React Spreadsheet Component & Keyboard Navigation

What is KendoReact
Getting Started
Unstyled Mode
Server Components
Components
- Animation
- Barcodes
- Buttons
- Chart Wizardnew
- Chartsupdated
- Common Utilities
- Conversational UIupdated
- Data Gridupdated
- Data Query
- Data Toolsupdated
- Date Inputs
- Date Math
- Dialogsupdated
- Drawing
- Dropdowns
- Editor
- Excel Export
- File Saver
- Form
- Gantt
- Gauges
- Indicators
- Inputsupdated
- Labels
- Layoutupdated
- ListBoxupdated
- ListView
- Map
- Notification
- OrgChart
- PDF Processing
- PDF Viewer
- PivotGrid
- Popup
- Progress Bars
- Ripple
- Schedulerupdated
- ScrollView
- Sortable
- Spreadsheet
- - Overview
  - Getting Started
  - Toolbar
  - Data Import and Export
  - Built-in Formulas and Functionsnew
  - Sheet Resizing
  - Custom Functions
  - Disabled Cells
  - Events
  - Keyboard Navigation
  - Globalization
  - API
- TaskBoard
- Tooltips
- TreeList
- TreeViewupdated
- Upload
Sample Applications
Styling & Themes
Common Features
Project Setup
Knowledge Base
Changelog
Updates
Troubleshooting

Components / Spreadsheet / Keyboard Navigation /

The keyboard navigation of the Spreadsheet is always available.

The Spreadsheet supports the following keyboard shortcuts:

SHORTCUT	DESCRIPTION
`Ctrl` + `A`	Selects the whole worksheet
`Ctrl` + `C`	Copies selected cells
`Ctrl` + `V`	Inserts copied or cut cells to a selected location within the worksheet
`Ctrl` + `X`	Cuts selected cells
`Ctrl` + `Y`	Repeats the last action, if possible, by using the `Redo` command
`Ctrl` + `Z`	Reverses the last action or deletes the last typed entry by using the `Undo` command
`Ctrl` + `select a cell`	Selects an adjacent or non adjacent cell
`Ctrl` + `select cells`	Selects a range of adjacent or nonadjacent cells. To simultaneously select more than one range of cells, repeat this command. The selected ranges can also overlap.
`Ctrl` + `select a row or column`	Selects an adjacent or nonadjacent row or column.
`Ctrl` + `select rows or columns`	Selects a range of adjacent or nonadjacent rows or columns. To simultaneously select more than one range of rows or columns, repeat this command. The selected ranges can also overlap.
`Arrow Keys`	Move a cell up, down, left, or right in a worksheet
`Ctrl` + `Arrow key`	Navigates to the last cell of the current series of data. If there is another set of data afterwards, the first cell of the new series will be selected. Otherwise, you will be navigated to the last cell of the worksheet in the corresponding direction
`Shift` + `Arrow key`	Selects (a range of) adjacent cells, rows, or columns, by extending the selection by one cell, row, or column
`Ctrl` + `Shift` + `Arrow key`	Extends the selection of cells to the last cell of the current series of data. If there is another set of data afterwards, the cell selection will be extended to the first cell of the new series of data. Otherwise, the cell selection will be extended to the last cell of the worksheet in the corresponding direction
`Backspace`	In the Formula bar, it deletes one character to the left from the formula text In cell selection mode, it removes the content of the active cell In cell editing mode, it deletes the character to the left of the insertion point
`Delete`	In the Formula bar, it deletes the character to the right of the insertion point from the formula text In cell selection mode, it removes the content from selected cells without affecting cell formats In cell editing mode, it deletes the character to the right of the insertion point
`End`	In cell selection mode, moves to the far right cell of the active row In a menu or submenu, selects the last command
`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 In the formula bar, `Ctrl` + `End` moves the cursor to the end of the text
`Enter`	In cell editing mode or in the Formula bar, completes a cell entry and selects the cell below In a data form, it moves to the first field in the next record In the command toolbar, opens a selected menu or performs the action for a selected command
`Alt` + `Enter`	In cell editing mode or in the Formula bar, creates a new row within the cell
`Esc`	In cell editing mode or in the Formula bar, cancels an entry in the cell or Formula Bar
`Home`	In cell selection mode, moves to the beginning of a row in a worksheet
`Ctrl` + `Home`	In cell selection mode, moves to the first cell (the top-left cell) on a worksheet In the formula bar, `Ctrl` + `Home` moves the cursor to the beginning of the text
`Ctrl` + `Shift` + `Home`	Extends the selection of cells to the beginning of the worksheet
`Page Down`	Moves one screen down in a worksheet
`Page Up`	Moves one screen up in a worksheet
`Tab`	In cell selection mode, moves one cell to the right in a worksheet. In range selection of cells, rows or columns, moves to the next cell within the active range. If the focus is on the last cell (the bottom-right cell) in the range, the focus will return to the first cell on the top-left If the currently active cell is the last cell in the Sheet (the cell on the last row in the last column), pressing `Tab` will move the focus outside of the Spreadsheet to the next focusable element on the page.
`Shift` + `Tab`	In cell selection mode, moves one cell to the right in a worksheet In range selection of cells, rows or columns, moves to the previous cell within the active range. If the focus is on the first cell (the top-left cell) in the range, the focus will return to the last cell on the bottom-right If the currently active cell is the first cell in the Sheet (the cell on the first row in the first column), pressing `Shift` + `Tab` will move the focus outside of the Sheet to the Named ranges ComboBox on the Spreadsheet Toolbar.

Example

View Source

Change Theme:

Keyboard Navigation

Suggested Links

In this article

Not finding the help you need?

Getting Started

Support Resources

Community

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Resources

Productivity and Design Tools

Keyboard Navigation

Suggested Links

In this article

Not finding the help you need?