At the beginning of computer technology, the Function keys were really useful. Nowadays, these keys become less useful but some of them are still really important if you work daily with Excel.
Shortcuts with the Function keys
| Action | Key |
|---|---|
| Help | F1 |
| Toggle Edit Mode | F2 |
| Paste a defined name into your formula (if you have defined a Name in your workbook) | F3 |
| Add dollars to the reference of your formula | F4 |
| Menu GoTo | F5 |
| (Obsolete) Go to the next Pane | F6 |
| Spell Check | F7 |
| Extend Selection (EXT appears in the status bar). In Extend Mode, when you move the active cell (with the mouse or the arrow). | F8 |
| Calculate the entire workbook (all the worksheets) Audit some parts of your formula | F9 |
| Activate the shortcuts of the ribbon | F10 |
| Add a Chart worksheet | F11 |
| Open the Save As menu | F12 |
Shortcuts with Shift and Function Keys
| Action | Key |
|---|---|
| Shift + F1 | |
| Add a comment in the cell | Shift + F2 |
| Insert the sign = and display the dialog box Function | Shift + F3 |
| Find Next | Shift + F4 |
| Open the dialog box Find | Shift + F5 |
| Paste the name formula (if you have defined Name in your worksheet) | Shift + F6 |
| Spell Check | Shift + F7 |
| Extend Selection (EXT appears in the status bar). In Extend Mode, when you move the active cell (with the mouse or the arrow), you select all the cells. | Shift + F8 |
| Calculate the entire workbook (all the worksheets) Audit some parts of your formula | Shift + F9 |
| Activate the shortcuts of the ribbon | Shift + F10 |
| Add a Chart worksheet | Shift + F11 |
| Open the Save As menu | Shift + F12 |
Shortcuts Ctrl + Function Keys
| Action | Key |
|---|---|
| Hide / Show the ribbon | Ctrl + F1 |
| Open the Print menu | Ctrl + F2 |
| Open the Name Manager | Ctrl + F3 |
| Close the workbook | Ctrl + F4 |
| Reduce the active Excel Windows | Ctrl + F5 |
| Workbook full size | Ctrl + F6 |
| Move with the arrows a reduce Excel workbook | Ctrl + F7 |
| Increase / Decrease the size of a reduce Excel workbook with the arrows | Ctrl + F8 |
| Minimize the active workbook | Ctrl + F9 |
| Worbook full size | Ctrl + F10 |
| [depreciated] Open Macro Excel 4 | Ctrl + F11 |
| Open the menu Open a workbook | Ctrl + F12 |
Shortcuts with Alt + Function keys
| Action | Key |
|---|---|
| Insert a Chart | Alt + F1 |
| Open the dialog box Save As | Alt + F2 |
| Activate the Cell Name Box | Alt + F3 |
| Close the workbook | Alt + F4 |
| Alt + F5 | |
| Alt + F6 | |
| Alt + F7 | |
| Open the Macro launcher | Alt + F8 |
| Alt + F9 | |
| Open the Object pane | Alt + F10 |
| Open the VBA Editor | Alt + F11 |
| Open Power Query Editor | Alt + F12 |
Shortcuts with Ctrl + Shift + Function Keys
| Action | Key |
|---|---|
| Excel Full Screen | Ctrl + Shift + F1 |
| Add a Conversation (Modern Comment) | Ctrl + Shift + F2 |
| Open the dialog box Create Name from Selection | Ctrl + Shift + F3 |
| Find the previous value | Ctrl + Shift + F4 |
| Open the menu Print menu | Ctrl + Shift + F12 |
