Function Keys

Function Keys Purpose
F1 Opens Excel help
F2 Moves the insertion point to the end of the content of the active cell
F3 Displays the Paste Name dialog box, which will show the names of named ranges.
F4 Cycles through all 4 types of cell references - absolute, mixed reference, and relative)
F5 Displays the Go To dialog box.
F6 Moves to the next pane in a worksheet that has been split.
F7 Displays the Spelling dialog box (the same as clicking Spelling on the Review tab.
F8 Turns on/off Extend mode.
F9 Calculates the workbook.
F10 Shows the key tips (the same as pressing ALT)
F11 Creates a chart from a selected range.
F12 Brings up the Save As dialog box.

Keyboard Shortcuts