Shorcuts – Function Key

Reading time: 10 minutes
Last Updated on 05/12/2021 by Frédéric LE GUEN

At the beginning of the 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.

Function keys alone

touche F1 Help
touche F2 Toogle to the Edit mode
touche F3 Paste name formula (if you have defined Name in your worksheet)
touche F4 Toogle the reference of a cell (block/un-block)
touche F5 Goto
touche F6 Go to the next pane.
touche F7 Spell Check
touche F8 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.
touche F9 Calculate the entire workbook (all the worksheets)
When you select a part of a formula, F9 convert the selection in result
touche F10 Activate Menu
touche F11 Add a chart
touche F12 Open the dialog box Save as ...

Function Keys + Shift

touche Shift + Shift + F1 What's this help
touche Shift + Shift + F2 Add a comment
touche Shift + Shift + F3 Insert the sign = and display the dialog box Function
touche Shift + Shift + F4 Find next
touche Shift + Shift + F5 Find
touche Shift + Shift + F6 Return to the previous Pane
touche Shift + Shift + F7  
touche Shift + Shift + F8 Toogle to the Mode ADD (you can see this information in the status bar). When you are in the Mode ADD, each clic select the cell WITHOUT unselected the previous one.
touche Shift + Shift + F9 Calculate the active worksheet
touche Shift + Shift + F10 Display the contextual menu
touche Shift + Shift + F11 Insert a new worksheet
touche Shift + Shift + F12 Open the dialog box Save as ...

Function Keys + Ctrl

touche control + Ctrl + F1 Hide / Display the Ribbon
touche control + Ctrl + F2 Toogle to the View before Print
touche control + Ctrl + F3 Define name
touche control + Ctrl + F4 Close the active workbook
touche control + Ctrl + F5 Restore Windows size
touche control + Ctrl + F6 Toogle to the next workbook
touche control + Ctrl + F7 Move a minimize window with the arrow
touche control + Ctrl + F8 Resize a reduce window with the arrow
touche control + Ctrl + F9 Minimize the active workbook
touche control + Ctrl + F10 Restore workbook
touche control + Ctrl + F11 Insert a Macro Excel 4
touche control + Ctrl + F12 Open the dialog box Open a workbook

Function keys + Alt

touche Alt + Alt + F1 Insert a new chart
touche Alt + Alt + F2 Display the dialog box Save As ...
touche Alt + Alt + F3  
touche Alt + Alt + F4 Quit Excel
touche Alt + Alt + F5  
touche Alt + Alt + F6  
touche Alt + Alt + F7  
touche Alt + Alt + F8 Display the Macro list
touche Alt + Alt + F9  
touche Alt + Alt + F10 Open the pane of the Object Selection
touche Alt + Alt + F11 Open the Visual Basic Editor
touche Alt + Alt + F12  

Shortcuts with Shift & Ctrl

touche Shift + touche control + Ctrl + Shift + F1  
touche Shift + touche control + Ctrl + Shift + F2  
touche Shift + touche control + Ctrl + Shift + F3 Names from labels
touche Shift + touche control + Ctrl + Shift + F4 Select each empty cells (one by one) from the active cell till the cell A1
touche Shift + touche control + Ctrl + Shift + F5  
touche Shift + touche control + Ctrl + Shift + F6 Go to the previous Workbook
touche Shift + touche control + Ctrl + Shift + F7  
touche Shift + touche control + Ctrl + Shift + F8  
touche Shift + touche control + Ctrl + Shift + F9  
touche Shift + touche control + Ctrl + Shift + F10 First, active the Ribbon. Second, display the parameter of the Ribbon
touche Shift + touche control + Ctrl + Shift + F11  
touche Shift + touche control + Ctrl + Shift + F12 Open the Print menu

Shortcuts with Shift & Alt

touche Shift + touche alt + Alt + Shift + F1 Insert a new worksheet
touche Shift + touche alt + Alt + Shift + F2 Open the dialog box Save As ...
touche Shift + touche alt + Alt + Shift + F3  
touche Shift + touche alt + Alt + Shift + F4 Close the active workbook
touche Shift + touche alt + Alt + Shift + F5  
touche Shift + touche alt + Alt + Shift + F6  
touche Shift