Excel function keys


Windows OS keys


Function key
(Useful keys shown in bold)
Description
F1Help - displays the Search online help dialog box
F2 Edit mode
F3 Displays the Paste Name dialog box
F4 Ready mode: Repeat the last action
Edit mode: cycle through absolute and relative reference combinations
Mode is shown on the left of the Status Bar
F5Displays the GoTo dialog box
F6Move to the next pane of a worksheet when in split view mode
F7Display the Spelling dialog box
F8The Extend mode switch - Extend Selection is displayed in the Status Bar
F9Recalculate all changed formulas in all open workbooks
F10Display Key tips. The same as Alt or forward slash /
F11Create a Chart sheet from the selection
F12Display the Save As dialog box