Excel Shortcut Key part 6
| Excel Shortcut Key part 6 | |
| Shortcut | Description |
| Alt+= | Creates a formula to sum all of the above cells. |
| Alt+’ | Allows formatting on a dialog box. |
| F1 | Opens the help menu. |
| F2 | Edits the selected cell. |
| F3 | After a name has been created, F3 will paste names. |
| F4 | Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. |
| F5 | Goes to a specific cell. For example, C6. |
| F6 | Move to the next pane. |
| F7 | Spell check selected text or document. |
| F8 | Enters Extend Mode. |
| F9 | Recalculates every workbook. |
| F10 | Activates the menu bar. |
| F11 | Creates a chart from selected data. |
| F12 | Save As option. |
| Shift+F1 | Opens the “What’s This?” window. |
| Shift+F2 | Allows the user to edit a cell comment. |
| Shift+F3 | Opens the Excel formula window. |
| Shift+F5 | Brings up a search box. |
| Shift+F6 | Move to previous pane. |
| Shift+F8 | Add to selection. |
| Shift+F9 | Performs calculate function on active sheet. |
| Ctrl+F3 | Open Excel Name Manager. |
| Ctrl+F4 | Closes current Window. |
| Ctrl+F5 | Restores window size. |
| Ctrl+F6 | Next workbook. |
| Ctrl+Shift+F6 | Previous workbook. |
| Ctrl+F7 | Moves the window. |
| Ctrl+F8 | Resizes the window. |
| Ctrl+F9 | Minimize current window. |
| Ctrl+F10 | Maximize currently selected window. |
| Ctrl+F11 | Inserts a macro sheet. |
| Ctrl+F12 | Opens a file. |
| Ctrl+Shift+F3 | Creates names by using those of either row or column labels. |
| Ctrl+Shift+F6 | Moves to the previous worksheet window. |
| Ctrl+Shift+F12 | Prints the current worksheet. |
| Alt+F1 | Inserts a chart. |
| Alt+F2 | Save As option. |
| Alt+F4 | Exits Excel. |
| Alt+F8 | Opens the macro dialog box. |
| Alt+F11 | Opens the Visual Basic editor. |
| Alt+Shift+F1 | Creates a new worksheet. |
| Alt+Shift+F2 | Saves the current worksheet. |