Excel – functions keys

Function keys

Function key
(Useful keys shown in bold)
F1 Help – 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
F5 Displays the GoTo dialog box
F6 Move to the next pane of a worksheet when in split view mode
F7 Display the Spelling dialog box
F8 The Extend mode switch – Extend Selection is displayed in the Status Bar
F9 Recalculate all changed formulas in all open workbooks
F10 Display Key tips. The same as Alt or forward slash /
F11 Create a Chart sheet from the selection
F12 Display the Save As dialog box
  • This example was developed in Excel 2013 Pro 64 bit.
  • Last modified: , [Australian Eastern Standard Time (AEST)]