Keyboard shortcuts in Blazor Spreadsheet
28 Oct 20269 minutes to read
The Blazor Spreadsheet supports keyboard shortcuts for performing clipboard, undo and redo, selection, navigation, editing, and other operations.
Formatting
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + B | ⌘ + B | Applies or removes bold formatting from the selected cells. |
| Ctrl + U | ⌘ + U | Applies or removes underline formatting from the selected cells. |
| Ctrl + I | ⌘ + I | Applies or removes italic formatting from the selected cells. |
| Ctrl + 5 | ⌘ + 5 | Applies or removes strikethrough formatting from the selected cells. |
Autofill
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + D | ⌘ + D | Fills the selected cells down. |
| Ctrl + R | ⌘ + R | Fills the selected cells right. |
Clipboard
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + C | ⌘ + C | Copies the selected cells to the clipboard. |
| Ctrl + X | ⌘ + X | Cuts the selected cells to the clipboard. |
| Ctrl + V | ⌘ + V | Pastes the clipboard content into the Spreadsheet. |
Undo/Redo
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + Z | ⌘ + Z | Reverses the last action performed. |
| Ctrl + Y | ⌘ + Y | Reapplies the last action that was undone. |
Selection
| Windows | MAC | Actions |
|---|---|---|
| Shift + Arrow Keys | ⇧ + Arrow Keys | Extends the current selection in the direction of the arrow key. |
| Ctrl + A | ⌘ + A | Selects all cells in the current worksheet. |
| Ctrl + Space | ⌘ + Space | Selects the active column. |
| Shift + Space | ⇧ + Space | Selects the active row. |
| Ctrl + Shift + Space | ⌘ + ⇧ + Space | Selects all cells in the worksheet. |
Navigation
| Windows | MAC | Actions |
|---|---|---|
| Arrow keys | Arrow keys | Navigates between adjacent cells in the direction of the arrow key. |
| Enter | Enter | Moves the active cell down one row. |
| Shift + Enter | ⇧ + Enter | Moves the active cell up one row. |
| Tab | Tab | Moves the active cell right one column. |
| Shift + Tab | ⇧ + Tab | Moves the active cell left one column. |
| Page Up | Page Up | Moves up one screen at a time. |
| Page Down | Page Down | Moves down one screen at a time. |
| Ctrl + Home | ⌘ + Home | Moves to the first cell in the current row. |
| Ctrl + End | ⌘ + End | Moves to the last used cell. |
| Ctrl + Arrow Keys | ⌘ + Arrow Keys | Moves to the edge of the current data region. |
Editing
| Windows | MAC | Actions |
|---|---|---|
| F2 | F2 | Enters edit mode for the selected cell. |
| Enter | Enter | Confirms the edit and moves the active cell down one row. |
| Shift + Enter | ⇧ + Enter | Confirms the edit and moves the active cell up one row. |
| Tab | Tab | Confirms the edit and moves the active cell right one column. |
| Shift + Tab | ⇧ + Tab | Confirms the edit and moves the active cell left one column. |
| Escape | Esc | Cancels the edit and restores the cell’s original value. |
Clear
| Windows | MAC | Actions |
|---|---|---|
| Delete | Delete | Clears the contents of the selected cells. |
Hyperlink
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + Click | ⌘ + Click | Opens the link in the selected cell. |
| Ctrl + K | ⌘ + K | Opens the hyperlink dialog to insert a new link or edit an existing one. |
File operations
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + O | ⌘ + O | Opens a workbook file. |
| Ctrl + S | ⌘ + S | Saves the workbook. |
Worksheet
| Windows | MAC | Actions |
|---|---|---|
| Shift + F11 | Shift + F11 | Adds a new worksheet. |
Filtering
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + Shift + L | ⌘ + ⇧ + L | Opens the filter dialog. |
Find and Replace
| Windows | MAC | Actions |
|---|---|---|
| Ctrl + F | ⌘ + F | Opens the Find and Replace dialog. |
The Command and Control keys on Mac devices can be interchanged. When this switch occurs, use the Command key in place of the Control key for the above-listed key interactions on Mac devices.