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.
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.
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.
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.
