New to Telerik UI for Blazor? Download Free 30-day trial

Spreadsheet - Keyboard Navigation

  • Keyboard-navigation.razor
  • SpreadsheetConstants.cs
Loading the demo source code...please wait.
Style in ThemeBuilder
  • Custom SASS variables
  • Atomic customizations
  • Sharing projects
Start Theming

Focus

  • Alt + W focuses the first component in the example

Spreadsheet Keyboard Navigation

The Spreadsheet component is a container that consists of several logically separated structural elements. Some of them implement the keyboard navigation specification of other Telerik components:

Each of the above components is part of the page tab sequence and can be navigated to using the Tab key. The list above illustrates the focus sequence. The only exception is the Sheet area which implements its own inner Tab-based navigation.

Upon opening any of the Spreadsheet Dialogs, the focus must move to the Dialog and navigation must be trapped within the Dialog. Upon closing the dialog if a manipulation on the Spreadsheet cell has been performed, focus must move to that cell. If no manipulation has been performed, focus must return to the Tool of the ToolBar that has opened the Dialog.

Sheet Area Shortcuts

  • Ctrl + C copies the selected cells (range).
  • Ctrl + V inserts copied or cut cells to a selected location within the worksheet.
  • Ctrl + X cuts the selected cells (range).
  • 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.
  • Delete deletes the character to the right in the Formula bar. In cell selection mode, removes the content from selected cells without affecting cell formats. In cell editing mode, deletes the character to the right of the insertion point.
  • Backspace Deletes one character to the left in the Formular bar. In cell selection mode, removes the content of the active cell. In cell editing mode, deletes the character to the left of the insertion point.

Selection Shortcuts

  • Ctrl + Select a cell selects an adjacent or non-adjacent cell.
  • Ctrl + Select cells selects a range of adjacent or non-adjacent.
  • Ctrl + A selects the whole worksheet.
  • 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 non-adjacent rows or columns.
  • 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.
  • Up / Down arrow selects the next or previous command in a menu or submenu.
  • Ctrl + Shift + End extends the cell selection 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 cell selection 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.

Navigation Shortcuts

  • Ctrl + Arrow key navigates to the end 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.
  • Arrow key moves one cell up, down, right of left in the worksheet.
  • Tab moves one cell to the right in a worksheet, when in cell selection mode. If the currently active cell is the last cell (the bottom-right cell) in the Sheet, pressing Tab will move the focus outside of the Sheet cells to the next focusable element on the page. In a dialog box, moves to the next focusable element in the Dialog. 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.
  • Shift + Tab moves to the previous cell in a worksheet, when in cell selection mode. If the currently active cell is the first cell (the top-left cell) in the Sheet, pressing Shift + Tab will move the focus outside of the Sheet to the Named ranges ComboBox. In a dialog box, moves to the previous focusable element. 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 top-left), the focus will return to the last (the bottom-left) cell in the range.
  • 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. In the Formula Bar, moves the cursor to the beginning of the text.
  • 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, moves the cursor to the end of the text.

Other Shortcuts

  • Alt + Space displays the Control menu for the Spreadsheet window.
  • Space + In a dialog box, performs the action for the selected button, or selects or clears a check box.
  • 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, executes the active action. In a dialog box, performs the action for the default command button in the dialog box.
  • Esc In cell editing mode or in the Formula bar, cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog box or message window.
  • Alt + H displays the Home tab on the ToolBar.
  • Alt + N displays the Insert tab on the ToolBar.
  • Alt + A displays the Data tab on the ToolBar.
  • Ctrl (Cmd on macOS) + Page Down activates the next sheet from the SheetBar if such exists.
  • Ctrl (Cmd on macOS) + Page Up activates the previous sheet from the SheetBar if such exists.

Sheet Bar Shortcuts

  • Tab moves the focus to the next focusable element in the Sheets Bar. If the last element is focused, pressing Tab will move the focus outside of the Spreadsheet.
  • Shift + Tab moves the focus to the previous focusable element in the Sheets Bar. If the first element is focused, pressing Tab will move the focus to the Sheet area.
  • Alt (Option on macOS) + Down Arrow opens the actions DropDownButton popup for the current active tab.

Description

This example provides a list of the available keyboard navigation shortcuts in the Telerik Spreadsheet. The component consists of several child components that provide additional keyboard shortcuts. Refer to the linked demos above.

This Blazor Spreadsheet Keyboard Navigation example is part of a unique collection of hundreds of Blazor demos, with which you can see all Telerik UI for Blazor components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in Telerik REPL for Blazor or ThemeBuilder.

Support & Learning Resources

An error has occurred. This application may no longer respond until reloaded.