List of Keyboard Shortcuts
The following table provides a list of the keyboard shortcuts the Spreadsheet supports.
Shortcuts | Description |
---|---|
Ctrl + A
|
Selects the whole worksheet |
Ctrl + C
|
Copies selected cells |
Ctrl + P
|
Displays the Print dialog box |
Ctrl + S
|
Saves the active spreadsheet file |
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 |
Down Arrow / Up Arrow key |
|
F2 |
Enters editing mode for the currently selected cell |
F10 |
Focuses the first tool of Spreadsheet toolbar |
Backspace |
|
Delete |
|
End |
|
Ctrl + End
|
|
Ctrl + Shift + End
|
|
Enter |
|
Alt + Enter
|
In cell editing mode or in the Formula bar creates a new row within the cell |
Esc |
|
Home |
|
Ctrl + Home
|
|
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 |
Spacebar |
In a dialog box, performs the action for the selected button, or selects or clears a check box |
Alt + Spacebar
|
Displays the Control menu for the Spreadsheet window |
Tab |
|
Shift + Tab
|
|
When the focus is within the Spreadsheet Sheet, fast way to navigate away from the Spreadsheet is to press Ctrl
+ End
(to move the focus to the last cell on the Sheet) and the Tab
. Similarly, to move the focus from the Sheet to the Spreadsheet Toolbar, press Ctrl
+ Home
and then Shift
+ Tab
.