Keyboard shortcuts in spreadsheets

previous page next page

Arrow keys: Move one cell up, down, left, or right
CTRL+arrow key: Move to the edge of the current data region
HOME: Move to the beginning of the row
CTRL+HOME: Move to the beginning of the sheet
CTRL+END: Move to the last cell on the sheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
PAGE DOWN: Move down one screen
PAGE UP: Move up one screen
ALT+PAGE DOWN: Move one screen to the right
ALT+PAGE UP: Move one screen to the left
CTRL+PAGE DOWN: Move to the next sheet
CTRL+PAGE UP: Move to the previous sheet
The TAB key: Move forward between unlocked cells on a protected sheet
SHIFT+TAB: Move backward between unlocked cells on a protected sheet

ENTER: Complete a cell entry and move down in the selection
CTRL+ENTER: Fill the selected cell range with the current entry
SHIFT+ENTER: Complete a cell entry and move up in the selection
The TAB key: Complete a cell entry and move to the right in the selection
CTRL+SHIFT+ENTER: Enter an array formula
SHIFT+TAB: Complete a cell entry and move to the left in the selection
ESC: Cancel a cell entry
Arrow keys: Move one character up, down, left, or right
HOME: Move to the beginning of the line
END: Move to the end of the line
ALT+0128 (on the numeric keypad, with Num Lock on): Enter the euro currency character

F2: Edit the active cell and position the insertion point at the end of the line
F9: Calculate all sheets in the active spreadsheet
= (equal sign): Start a formula
ALT+= (equal sign): Insert a SUM formula by using the AutoSum command
BACKSPACE: Delete the character to the left of the insertion point, or delete the selection
DELETE: Delete the character to the right of the insertion point, or delete the selection
CTRL+SHIFT+ENTER: Enter a formula as an array formula

F2: Edit the active cell and put the insertion point at the end of the line
F4: Toggle between absolute mode and relative mode for the currently selected reference
ESC: Cancel an entry in the cell
BACKSPACE: Clear the active cell and leave in edit mode, or delete the preceding character in the active cell as you edit the cell contents
ENTER: Complete a cell entry

ENTER: Move from top to bottom within the selection (down), or move in the direction that is selected in the Commands and Options dialog box
SHIFT+ENTER: Move from bottom to top within the selection (up), or move opposite to the direction that is selected in the Commands and Options dialog box
The TAB key: Move from left to right within the selection, or move down one cell if only one column is selected
SHIFT+TAB: Move from right to left within the selection, or move up one cell if only one column is selected

SHIFT+arrow key: Extend the selection by one cell
CTRL+/: Select the array containing the active cell.
CTRL+SHIFT+arrow key: Extend the selection to the last nonblank cell in the same column or row as the active cell
SHIFT+HOME: Extend the selection to the beginning of the row
CTRL+SHIFT+HOME: Extend the selection to the beginning of the sheet
CTRL+SHIFT+END: Extend the selection to the last used cell on the sheet (lower-right corner)
CTRL+SPACEBAR: Select the entire column
SHIFT+SPACEBAR: Select the entire row
CTRL+A: Select the entire sheet
SHIFT+PAGE UP: Extend the selection up one screen

CTRL+T: Enable AutoFilter on the selected range
ALT+DOWN ARROW: Open the AutoFilter drop-down list for the selected cell
The TAB key: Alternately move to the most recently selected item, the OK button, and the Cancel button in an AutoFilter drop-down list
Arrow keys: Move to the next or previous item in an AutoFilter drop-down list
Letter or number keys: Move to the first item that starts with that letter or number in an AutoFilter drop-down list
SHIFT+arrow keys: Extend the selection in an AutoFilter drop-down list
SPACEBAR: Select or clear the check boxes for the selected items in an AutoFilter drop-down list
ENTER: Close an AutoFilter drop-down list and apply any changes you made
ESC: Close an AutoFilter drop-down list without applying your changes

ALT+RIGHT ARROW: Go forward to a Help topic you viewed previously
ALT+LEFT ARROW: Go back to a Help topic you viewed previously
The TAB key: Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic
SHIFT+TAB: Select the previous hidden text or hyperlink
ENTER: Perform the action for the selected Show All, Hide All, hidden text, or hyperlink
UP ARROW or DOWN ARROW: Scroll toward the beginning or end of a Help topic
PAGE UP or PAGE DOWN: Scroll toward the beginning or end of a Help topic in larger increments
HOME or END: Go to the beginning or end of a Help topic
CTRL+P: Print the current Help topic
CTRL+A: Select the entire Help topic
CTRL+C: Copy selection to the Clipboard
SHIFT+F10: Display shortcut menu

previous page start next page