THIS appendix lists keyboard-accessible commands and controls in Microsoft Excel 2010. Besides being an essential accessibility table, it also provides a glimpse into the depth and breadth of the features available.
Keyboard shortcuts are divided into the following categories in this appendix:
Keyboard Shortcuts by Key
Function keys
Control and navigation keys
Numeric keys
Symbols and keypad
Alphabetical keys
Keyboard Shortcuts by Task
Insert charts and select chart elements
Work in dialog box edit boxes
Work in dialog boxes
Edit data
Enter and calculate formulas
Enter data
Extend a selection
Filter lists
Work in the Format Cells dialog box, Border tab
Format data
Get Help
Work in the Help window
Insert, delete, and copy cells
Work with macros
Work with the ribbon and buttons
Move and scroll in End mode
Move and scroll in worksheets
Move within a selected range
Work in Print Preview
Select cells, rows, columns, and objects
Select cells with special characteristics
Show, hide, and outline data
Work with options menus or messages
Work with task panes
Navigate the Windows and Office interface
Work with worksheets
This section lists the available keyboard shortcuts according to their position on the keyboard.
Table B-1. Function Keys
Press | To |
|---|---|
F1 | Display the Help window. |
Ctrl+F1 | Show/hide the ribbon. |
Alt+F1 | Insert a chart as an object. |
Shift+Alt+F1 | Insert a new worksheet. |
Ctrl+Alt+F1 | Insert a Microsoft Excel 4 macro worksheet. |
F2 | Toggle Selection, Edit, and Enter/Point modes. |
Shift+F2 | Insert/edit a comment. |
Alt+F2 | Display the Save As dialog box. |
Shift+Alt+F2 | Save |
Ctrl+Alt+F2 | Display the Open dialog box. |
Shift+Ctrl+Alt+F2 | Display the Print dialog box. |
F3 | Display the Paste Name dialog box. |
Shift+F3 | Display the Insert Function dialog box. |
Ctrl+F3 | Display the Name Manager dialog box. |
Shift+Ctrl+F3 | Display the Create Names From Selection dialog box. |
Ctrl+Alt+F3 | Display the New Name dialog box. |
F4 | Redo |
Shift+F4 | Find the next instance of the most recent search. |
Ctrl+F4 | Close the workbook. |
Alt+F4 | Close the application. |
Shift+Ctrl+F4 | Find the previous instance of the most recent search. |
Shift+Alt+F4 | Close the application. |
Ctrl+Alt+F4 | Close the application. |
Shift+Ctrl+Alt+F4 | Close the application. |
F5 | Display the Go To dialog box. |
Shift+F5 | Display the Find And Replace dialog box. |
Ctrl+F5 | Restore the window. |
Shift+F6 | Display shortcut key labels. (Or, you can press F6 twice.) |
Ctrl+F6 | Move to the next window. |
Shift+Ctrl+F6 | Move to the previous window. |
F7 | Check spelling. |
Ctrl+F7 | Move the window. |
F8 | Extend Selection mode. |
Shift+F8 | Add to Selection mode. |
Alt+F8 | Display the Macro dialog box. |
F9 | Calculate all, or when a portion of a formula is selected, calculate the selected portion. |
Shift+F9 | Calculate the active worksheet. |
Ctrl+F9 | Minimize the active window. |
Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Ctrl+Shift+Alt+F9 | Recheck dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated. |
F10 | Display shortcut key labels. |
Shift+F10 | Activate shortcut (context) menus. |
Ctrl+F10 | Toggle the maximized/restored window. |
F11 | Insert a chart on a new worksheet. |
Shift+F11 | Create a new worksheet. |
Ctrl+F11 | Create a new macro worksheet. |
Alt+F11 | Show the Visual Basic Editor. |
F12 | Display the Save As dialog box. |
Shift+F12 | Save |
Ctrl+F12 | Display the Open dialog box. |
Shift+Ctrl+F12 | Display the Print window. |
Table B-2. Control and Navigation Keys
Press | To |
|---|---|
Backspace | Edit and clear. |
Shift+Backspace | Collapse the selection to the active cell. |
Ctrl+Backspace | Show the active cell. |
Alt+Backspace | Undo |
Delete | Clear |
Shift+Delete | Cut |
Ctrl+Delete | Clear |
End | Toggle End mode. |
Shift+End | Toggle End mode (and extend when you press Shift+an arrow key). |
Ctrl+End | Select the last cell in the worksheet. |
Shift+Ctrl+End | Extend the selection to the last cell in the worksheet. |
Esc | Cancel (edit, copy, cut, dialog boxes, and so on). |
Shift+Esc | Cancel (edit, copy, cut, dialog boxes, and so on). |
Ctrl+Esc | Display the Windows Start menu. |
Shift+Ctrl+Esc | Display the Windows Task Manager. |
Enter | Enter the value, and move down. |
Shift+Enter | Enter the value, and move up. |
Ctrl+Enter | Fill the value in edited cell into all cells, and do not move. |
Alt+Enter | Redo |
Shift+Ctrl+Enter | Fill the value in edited cell into all cells, and do not move. |
Home | Select the first cell in the row. |
Shift+Home | Extend the selection to the first cell in the row. |
Ctrl+Home | Select the first cell in the window (or pane). |
Shift+Ctrl+Home | Extend the selection to the first cell in the window or pane. |
Insert | Toggle Overwrite mode in Edit mode. |
Shift+Insert | Paste |
Ctrl+Insert | Copy |
Left Arrow | Move left one cell. |
Down Arrow | Move down one cell. |
Shift+Down Arrow | Extend the selection down one cell. |
Ctrl+Down Arrow | Select the last cell in the region down. |
Alt+Down Arrow | Open the list (AutoComplete, Filter, Pick From List, or Validation). |
Shift+Ctrl+Down Arrow | Extend the selection down to the last cell in the current region or the first cell in the next region. |
Shift+Left Arrow | Extend the selection left one cell. |
Ctrl+Left Arrow | Select the leftmost cell in the current region or the rightmost cell in the next region. |
Shift+Ctrl+Left Arrow | Extend the selection left to the last cell in the current region or the first cell in the next region. |
Shift+Alt+Left Arrow | Ungroup |
Ctrl+Alt+Left Arrow | Move the active cell to the upper-left cell of the selection. |
Right Arrow | Move right one cell. |
Shift+Right Arrow | Extend the selection right one cell. |
Ctrl+Right Arrow | Select the last cell to the right in the current region or the first cell in the next region. |
Shift+Ctrl+Right Arrow | Extend the selection to the right, to the last cell in the current region, or the first cell in the next region. |
Shift+Alt+Right Arrow | Group |
Ctrl+Alt+Right Arrow | Move the active cell to the next nonadjacent region within the selection. |
Up Arrow | Move up one cell. |
Shift+Up Arrow | Extend the selection up one cell. |
Ctrl+Up Arrow | Select the cell at the top of the region. |
Shift+Ctrl+Up Arrow | Extend the selection up to the end of the region. |
Page Down | Scroll down one page. |
Shift+Page Down | Extend the selection down one page. |
Ctrl+Page Down | Move to the next worksheet. |
Alt+Page Down | Scroll one page right. |
Shift+Ctrl+Page Down | Extend the selection one worksheet down. |
Shift+Alt+Page Down | Extend the selection one page right. |
Page Up | Scroll up one page. |
Shift+Page Up | Extend the selection one page up. |
Ctrl+Page Up | Move to the previous worksheet. |
Alt+Page Up | Scroll one page left. |
Shift+Ctrl+Page Up | Extend the selection one worksheet up. |
Shift+Alt+Page Up | Extend the selection one page left. |
Return | Enter the value, and move down. |
Shift+Return | Enter the value, and move up. |
Ctrl+Return | Fill the value in the edited cell into all selected cells and do not move. |
Alt+Return | Redo |
Shift+Ctrl+Return | Fill the value in the edited cell into all selected cells and do not move. |
Shift+Spacebar | Select row. |
Ctrl+Spacebar | Select column. |
Shift+Ctrl+Spacebar | Select all. |
Tab | Move to the next cell to the right. |
Shift+Tab | Move to the next cell to the left. |
Ctrl+Tab | Move to the next window. |
Alt+Tab | Move to the next application. |
Shift+Ctrl+Tab | Move to the previous window. |
Shift+Alt+Tab | Indent |
Ctrl+Alt+Tab | Outdent |
Table B-3. Numeric Keys
Press | To |
|---|---|
Ctrl+0 | Hide the selected column. |
Ctrl+1 | Display the Format Cells dialog box. |
Shift+Ctrl+1 | Apply the two-decimal-place Number format with the thousands separator. |
Ctrl+2 | Toggle bold formatting. |
Shift+Ctrl+2 | Apply the Time (AM/PM) format. |
Ctrl+3 | Toggle italic formatting. |
Shift+Ctrl+3 | Apply the Date format. |
Ctrl+4 | Toggle underline formatting. |
Shift+Ctrl+4 | Apply the Currency format. |
Ctrl+5 | Toggle strikethrough formatting. |
Shift+Ctrl+5 | Apply the Percentage format. |
Ctrl+6 | Toggle the display of objects (between Show, Hide, and Show Placeholders). |
Shift+Ctrl+6 | Apply the two-place exponential Scientific format. |
Shift+Ctrl+7 | Apply the Outline border format. |
Ctrl+8 | Toggle the outline symbol display. |
Shift+Ctrl+8 | Select the current region. |
Ctrl+9 | Hide the selected row. |
Shift+Ctrl+9 | Show the row. |
Table B-4. Symbols and Keypad
Press | To |
|---|---|
Ctrl+’ (apostrophe) | Copy the underlying value (entered value or exact formula) of the above cell, and edit. |
Alt+’ (apostrophe) | Display the Style dialog box. |
Shift+Ctrl+’ (apostrophe) | Copy the displayed value in the above cell and edit. |
Ctrl+– (hyphen) | Display the Delete dialog box. |
Shift+Ctrl+– (hyphen) | Remove all the borders. |
Shift+Ctrl+, (comma) | Fill down. |
Ctrl+. (period) | Rotate the active cell through the corners of the selection. |
Shift+Ctrl+. (period) | Fill right. |
Ctrl+/ (slash) | Select array. |
Ctrl+; (semicolon) | Insert the current date. |
Shift+Ctrl+; (semicolon) | Insert the current time. |
Ctrl+[ (open bracket) | Select the direct precedent cells. |
Shift+Ctrl+[ (open bracket) | Select all the precedent cells. |
Ctrl+] (close bracket) | Select the directly dependent cells. |
Shift+Ctrl+] (close bracket) | Select all the dependent cells. |
Ctrl+Shift+{ (open brace) | Select all the cells directly or indirectly referenced by formulas in the selection. |
Ctrl+Shift+} (close brace) | Select cells that contain formulas that directly or indirectly reference the active cell. |
Ctrl+` (single left quotation mark) | Display formulas. |
Shift+Ctrl+` (single left quotation mark) | Apply the General format. |
Ctrl+= (equal sign) | Calculate now. |
Alt+= (equal sign) | AutoSum |
Shift+Ctrl+= (equal sign) | Display the Insert dialog box. |
Ctrl+Add (keypad) | Display the Insert dialog box. |
Ctrl+Decimal (keypad) | Rotate the active cell through the corners of the selection. |
Ctrl+Divide (keypad) | Select the array. |
Ctrl+Multiply (keypad) | Select the current region. |
Ctrl+Subtract (keypad) | Display the Delete dialog box. |
Table B-5. Alphabetical Keys
Press | To |
|---|---|
Ctrl+A | Select the current region or select all. |
Shift+Ctrl+A | Insert arguments in the formula. |
Ctrl+B | Apply bold formatting. |
Ctrl+C | Copy |
Ctrl+D | Fill down. |
Ctrl+F | Display the Find And Replace dialog box, Find tab. |
Shift+Ctrl+F | Display the Format Cells dialog box, Font tab. |
Ctrl+G | Display the Go To dialog box. |
Ctrl+H | Display the Find And Replace dialog box, Replace tab. |
Ctrl+I | Apply italic formatting. |
Ctrl+K | Display the Insert Hyperlink dialog box. |
Ctrl+L | Display the Create Table dialog box. |
Shift+Ctrl+L | Toggle AutoFilter. |
Ctrl+N | Create a new workbook. |
Ctrl+O | Display the Open dialog box. |
Shift+Ctrl+O | Select the first cell containing a comment. |
Ctrl+P | Display the Print window. |
Shift+Ctrl+P | Display the Format Cells dialog box, Font tab. |
Ctrl+R | Fill right. |
Ctrl+S | Save the workbook. |
Ctrl+T | Display the Create Table dialog box. |
Shift+Ctrl+T | Toggle the total row (when the table is selected). |
Ctrl+U | Toggle the underline format. |
Ctrl+V | Paste |
Ctrl+Alt+V | Display the Paste Special dialog box. |
Ctrl+W | Close the window. |
Ctrl+X | Cut |
Ctrl+Y | Redo |
Ctrl+Z | Undo |