Spreadsheet: 104267d1301924707-learning-keyboard-shortcuts-for-excel-shortcut-keys
Sheet: FUNCTION KEYS

Key | Description
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.
F6 | Switches to the next pane in a worksheet that has been split (Window menu, [NAME] 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.
[NAME] | 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.