Below are additional Function keys which I consider an another excel Hot Keys. If you love my first part definitely this part will be of interest to you also.
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, 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 Excel Control Keys Part 1 of 3than 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. |
Hope You like it.. Check for the Part 1 and Part 3.
[…] From time to time I am sharing some Tips about Microsoft Excel since I am a heavy user of this program. So here my sharing for today. You can see my other article at my archive page for Microsoft Excel. […]
[…] Another Excel Control Hot Key […]