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), you select all the cells.	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
	Ctrl + F5
	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
	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