The following lists contain function shortcut keys, with descriptions of their functionality.
|F1||Displays the Help task pane.|
|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.
|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.
|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 macr
|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.|