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 |
Moves to the edge of the current data region of the active worksheet |
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 nonblank cell in the same row or column as the active cell |
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
|
Moves to the beginning of a worksheet |
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
|
Moves to the previous cell in a worksheet or the previous option in a dialog box |