Keyboard shortcuts in spreadsheets
For information about the keys to activate and deactivate the Microsoft Office Spreadsheet Component on the page, see Help in your design program.
Keys for moving and
scrolling in a spreadsheet
- 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
Keys for moving with SCROLL LOCK on
- SCROLL LOCK
- Turn SCROLL LOCK on or off
- UP ARROW or DOWN ARROW
- Scroll one row up or down
- LEFT ARROW or RIGHT ARROW
- Scroll one column left or right
- SHIFT+F11
- Insert a new sheet
- CTRL+PAGE DOWN
- Move to the next sheet
- CTRL+PAGE UP
- Move to the previous sheet
Keys for entering data on a
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+B
- Apply or remove bold formatting
- CTRL+I
- Apply or remove italic formatting
- CTRL+U
- Apply or remove an underline
- 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
Keys for inserting, deleting, and copying a selection
- CTRL+C
- Copy the selection
- CTRL+X
- Cut the selection
- CTRL+V
- Paste the selection
- DELETE
- Clear the contents of the selection
- CTRL+Z
- Undo the last action
Keys for moving within a selection
- 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
Keys for selecting cells, columns, or rows
- 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
Keys for working with AutoFilter drop-down lists
- 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
Keys for working in the Help window
- F6
- Switch between the navigation pane and topic pane
- ALT+O
- Display the Options menu to access any Help toolbar command
- ALT+SPACEBAR
- Display the program Control menu
- ALT+F4
- Close the Help window
Keys for working in the navigation pane
- CTRL+TAB
- Switch to the other tab
- ENTER
- Open or close a selected book, or open a selected Help topic
- DOWN ARROW
- Select the next book or Help topic
- UP ARROW
- Select the previous book or Help topic
- SHIFT+F10
- Display shortcut menu
Keys for working in the topic pane
- 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