Shortcuts – Function Key Excel

Shortcuts – Function Key Excel
Last Updated on 25/06/2023
Reading time: 2 minutes

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

ActionKey
HelpF1
Toggle Edit ModeF2
Paste a defined name into your formula (if you have defined a Name in your workbook)F3
Add dollars to the reference of your formulaF4
Menu GoToF5
(Obsolete) Go to the next PaneF6
Spell CheckF7
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 ribbonF10
Add a Chart worksheetF11
Open the Save As menuF12

Shortcuts with Shift and Function Keys

ActionKey
Shift + F1
Add a comment in the cellShift + F2
Insert the sign = and display the dialog box FunctionShift + F3
Find NextShift + F4
Open the dialog box FindShift + F5
Paste the name formula (if you have defined Name in your worksheet)Shift + F6
Spell CheckShift + 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 ribbonShift + F10
Add a Chart worksheetShift + F11
Open the Save As menuShift + F12

Shortcuts Ctrl + Function Keys

ActionKey
Hide / Show the ribbonCtrl + F1
Open the Print menuCtrl + F2
Open the Name ManagerCtrl + F3
Close the workbookCtrl + F4
Ctrl + F5
Ctrl + F6
Move with the arrows a reduce Excel workbookCtrl + F7
Increase / Decrease the size of a reduce Excel workbook with the arrowsCtrl + F8
Minimize the active workbookCtrl + F9
Worbook full sizeCtrl + F10
Ctrl + F11
Open the menu Open a workbookCtrl + F12

Shortcuts with Alt + Function keys

ActionKey
Insert a ChartAlt + F1
Open the dialog box Save AsAlt + F2
Activate the Cell Name BoxAlt + F3
Close the workbookAlt + F4
Alt + F5
Alt + F6
Alt + F7
Open the Macro launcherAlt + F8
Alt + F9
Open the Object paneAlt + F10
Open the VBA EditorAlt + F11
Open Power Query EditorAlt + F12

Shortcuts with Ctrl + Shift + Function Keys

ActionKey
Excel Full ScreenCtrl + Shift + F1
Add a Conversation (Modern Comment)Ctrl + Shift + F2
Open the dialog box Create Name from SelectionCtrl + Shift + F3
Find the previous valueCtrl + Shift + F4
Open the menu Print menuCtrl + Shift + F12

Leave a Reply

Your email address will not be published. Required fields are marked *

Shortcuts – Function Key Excel

Reading time: 2 minutes
Last Updated on 25/06/2023

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

ActionKey
HelpF1
Toggle Edit ModeF2
Paste a defined name into your formula (if you have defined a Name in your workbook)F3
Add dollars to the reference of your formulaF4
Menu GoToF5
(Obsolete) Go to the next PaneF6
Spell CheckF7
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 ribbonF10
Add a Chart worksheetF11
Open the Save As menuF12

Shortcuts with Shift and Function Keys

ActionKey
Shift + F1
Add a comment in the cellShift + F2
Insert the sign = and display the dialog box FunctionShift + F3
Find NextShift + F4
Open the dialog box FindShift + F5
Paste the name formula (if you have defined Name in your worksheet)Shift + F6
Spell CheckShift + 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 ribbonShift + F10
Add a Chart worksheetShift + F11
Open the Save As menuShift + F12

Shortcuts Ctrl + Function Keys

ActionKey
Hide / Show the ribbonCtrl + F1
Open the Print menuCtrl + F2
Open the Name ManagerCtrl + F3
Close the workbookCtrl + F4
Ctrl + F5
Ctrl + F6
Move with the arrows a reduce Excel workbookCtrl + F7
Increase / Decrease the size of a reduce Excel workbook with the arrowsCtrl + F8
Minimize the active workbookCtrl + F9
Worbook full sizeCtrl + F10
Ctrl + F11
Open the menu Open a workbookCtrl + F12

Shortcuts with Alt + Function keys

ActionKey
Insert a ChartAlt + F1
Open the dialog box Save AsAlt + F2
Activate the Cell Name BoxAlt + F3
Close the workbookAlt + F4
Alt + F5
Alt + F6
Alt + F7
Open the Macro launcherAlt + F8
Alt + F9
Open the Object paneAlt + F10
Open the VBA EditorAlt + F11
Open Power Query EditorAlt + F12

Shortcuts with Ctrl + Shift + Function Keys

ActionKey
Excel Full ScreenCtrl + Shift + F1
Add a Conversation (Modern Comment)Ctrl + Shift + F2
Open the dialog box Create Name from SelectionCtrl + Shift + F3
Find the previous valueCtrl + Shift + F4
Open the menu Print menuCtrl + Shift + F12

Leave a Reply

Your email address will not be published. Required fields are marked *