Function Keys in Microsoft Excel: Function Keys in Microsoft Excel:The following is a table of function keys available in Microsoft Excel. The left column gives the desired action and the right column gives the associated function key.
| Desired Action | Function Key |
|---|---|
| Display Help or the Office Assistant Print command. | F1 |
| What's this? | SHIFT+F1 |
| Insert a chart sheet. | ALT+F1 |
| Insert a new worksheet. | ALT+SHIFT+F1 |
| Edit the active cell. | F2 |
| Edit a cell comment. | SHIFT+F2 |
| Save As command. | ALT+F2 |
| Save command. | SHIFT+ALT+F2 |
| Paste a name into a formula. | F3 |
| Paste a function into a formula. | SHIFT+F3 |
| Define a name. | CONTROL+F3 |
| Create names by using row and column labels. | SHIFT+CONTROL+F3 |
| Repeat the last action. | F4 |
| Repeat the last Find (Find Next). | SHIFT+F4 |
| Close the window. | CONTROL+F4 |
| Exit. | ALT+F4 |
| Go To. | F5 |
| Display the Find dialog box. | SHIFT+F5 |
| Restore the window size. | CONTROL+F5 |
| Move to the next pane. | F6 |
| Move to the previous pane. | SHIFT+F6 |
| Move to the next workbook window. | CONTROL+F6 |
| Move to the previous workbook window. | CONTROL+SHIFT+F6 |
| Spelling command. | F7 |
| Move the window. | CONTROL+F7 |
| Extend a selection. | F8 |
| Add to the selection. | SHIFT+F8 |
| Resize the window. | CONTROL+F8 |
| Display the Macro dialog box. | ALT+F8 |
| Calculate all sheets in all open workbooks. | F9 |
| Calculate the active worksheet. | SHIFT+F9 |
| Minimize the workbook. | CONTROL+F9 |
| Make the menu bar active. | F10 |
| Display a shortcut menu. | SHIFT+F10 |
| Maximize or restore the workbook window. | CONTROL+F10 |
| Create a chart. | F11 |
| Insert a new worksheet. | SHIFT+F11 |
| Insert a Microsoft Excel 4.0 macro sheet. | CONTROL+F11 |
| Display Visual Basic Editor. | ALT+F11 |
| Save As command. | F12 |
| Save command. | SHIFT+F12 |
| Open command. | CONTROL+F12 |
| Print command. | CONTROL+SHIFT+F12 |
Contact us at infotechaccess@server.rehab.uiuic.edu