F1 | Displays the Help task pane. |
| |
| CTRL+F1 closes and reopens the current task pane. |
| |
| ALT+F1 creates a chart of the data in the current range. |
| |
| ALT+SHIFT+F1 inserts a new worksheet. |
F2 | Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. |
| |
| SHIFT+F2 edits a cell comment. |
F3 | Pastes a defined name into a formula. |
| |
| SHIFT+F3 displays the Insert Function dialog box. |
F4 | Repeats the last command or action, if possible. |
| |
| CTRL+F4 closes the selected workbook window. |
F5 | Displays the Go To dialog box. |
| |
| CTRL+F5 restores the window size of the selected workbook window. |
ARROW KEYS | Move one cell up, down, left, or right in a worksheet. |
| |
| CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet. |
| |
| SHIFT+ARROW KEY extends the selection of cells by one cell. |
| |
| CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell. |
| |
| LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow keys switch between the main menu and the submenu. |
| |
| DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. |
| |
| In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. |
| |
| ALT+DOWN ARROW opens a selected drop-down list. |
F6 | Switches to the next pane in a worksheet that has been split (Window menu, Split command). |
| |
| SHIFT+F6 switches to the previous pane in a worksheet that has been split. |
| |
| CTRL+F6 switches to the next workbook window when more than one workbook window is open. |
| |
| Note When the task pane is visible, F6 and SHIFT+F6 include that pane when switching between panes. |
F7 | Displays the Spelling dialog box to check spelling in the active worksheet or selected range. |
| |
| CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ESC. |
F8 | Turns extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection. |
| |
| SHIFT+F8 enables you to add a non-adjacent cell or range to a selection of cells by using the arrow keys. |
| |
| CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized. |
| |
| ALT+F8 displays the Macro dialog box to run, edit, or delete a macro. |
F9 | Calculates all worksheets in all open workbooks. |
| |
| F9 followed by ENTER (or followed by CTRL+SHIFT+ENTER for array formulas) calculates the selected a portion of a formula and replaces the selected portion with the calculated value. |
| |
| SHIFT+F9 calculates the active worksheet. |
| |
| CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| |
| CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| |
| CTRL+F9 minimizes a workbook window to an icon. |
F10 | Selects the menu bar or closes an open menu and submenu at the same time. |
| |
| SHIFT+F10 displays the shortcut menu for a selected item. |
| |
| ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. |
| |
| CTRL+F10 maximizes or restores the selected workbook window. |
F11 | Creates a chart of the data in the current range. |
| |
| SHIFT+F11 inserts a new worksheet. |
| |
| ALT+F11 opens the Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA). |
| |
| ALT+SHIFT+F11 opens the Microsoft Script Editor, where you can add text, edit HTML tags, and modify any script code. |
F12 | Displays the Save As dialog box. |
0 Comments