Function Keys

F1	Displays the Excel Task Pane.
F2	Edits the active cell, putting the cursor at the end. This is only available when the following option is ticked. (Advanced, Editing options - allow editing directly in cells).
F3	Displays the Paste Name dialog box. This dialog box is only displayed if the active workbook contains at least one named range.
F4	When you are not editing a cell this repeats the last command or action. When you are editing a cell this toggles between relative, absolute and mixed cell references.
F5	Displays the GoTo dialog box.
F6	Moves to the next item (worksheet, ribbon, task pane).
F7	Displays the Spelling dialog box.
F8	Toggles whether to extend a selection with the arrow keys. You will see the text "Extend Selection" appear in the status bar.
F9	Smart Recalculation. Calculates All the worksheets in All the open workbooks. (only cells containing formulas that have changed since the last calculation will be updated). Replaces the highlighted part of a formula with its result to help debug when using the formula bar.
F10	Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
F11	Creates a chart (on a separate chart sheet) using the highlighted range as the data source.
F12	Displays the Save As dialog box.

F1 Displays the Excel Task Pane.
F2 Edits the active cell, putting the cursor at the end. This is only available when the following option is ticked. (Advanced, Editing options - allow editing directly in cells).
F3 Displays the Paste Name dialog box. This dialog box is only displayed if the active workbook contains at least one named range.
F4 When you are not editing a cell this repeats the last command or action. When you are editing a cell this toggles between relative, absolute and mixed cell references.
F5 Displays the GoTo dialog box.
F6 Moves to the next item (worksheet, ribbon, task pane).
F7 Displays the Spelling dialog box.
F8 Toggles whether to extend a selection with the arrow keys. You will see the text "Extend Selection" appear in the status bar.
F9 Smart Recalculation. Calculates All the worksheets in All the open workbooks. (only cells containing formulas that have changed since the last calculation will be updated). Replaces the highlighted part of a formula with its result to help debug when using the formula bar.
F10 Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
F11 Creates a chart (on a separate chart sheet) using the highlighted range as the data source.
F12 Displays the Save As dialog box.