Keyboard shortcuts in spreadsheets

previous page next page

For information about the keys to activate and deactivate the Microsoft Office Spreadsheet Component on the page, see Help in your design program.

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

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
CTRL+SHIFT+ENTER: Enter a formula as an array formula

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+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