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	Selects the next or previous command when a menu or submenu is open In a dialog box, the arrow keys move between options in an active drop-down list, or between options in a group of options
F2	Enters editing mode for the currently selected cell
F10	Focuses the first tool of Spreadsheet toolbar
Backspace	Deletes one character to the left in the Formula Bar Removes the content of the active cell In cell editing mode, it deletes the character to the left of the insertion point
Delete	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	Goes to the far right cell of the active row Selects the last command on a visible and active menu or submenu
Ctrl + End	Moves to the last cell on a worksheet, in the lowest used row of the used column on the far right If the cursor is in the formula bar, Ctrl + End moves the cursor to the end of the text Ctrl + End moves to the last cell on a worksheet, in the lowest used row of the used column on the far right
Ctrl + Shift + End	Extends the selection of cells to the last used cell on the worksheet located in lower-right corner If the cursor is in the formula bar, Ctrl + Shift + End selects all text in the formula bar from the cursor position to the end
Enter	Completes a cell entry from the cell or the Formula Bar, and selects the cell below In a data form, it moves to the first field in the next record Opens a selected menu or performs the action for a selected command In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline)
Alt + Enter	In cell editing mode or in the Formula bar creates a new row within the cell
Esc	Cancels an entry in the cell or Formula Bar Closes an open menu or submenu, dialog box, or message window
Home	Moves to the beginning of a row in a worksheet Selects the first command on the menu when a menu or submenu is visible
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	Moves one cell to the right in a worksheet Moves to the next option or option group in a dialog box Moves a cell within an active range of cells, rows, or columns.
Shift + Tab	Moves to the previous cell in a worksheet or the previous option in a dialog box

See Also

• List of Formulas and Functions
• User Guide