Function Keys

F1Displays the Excel Task Pane.
F2Edits 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).
F3Displays the Paste Name dialog box. This dialog box is only displayed if the active workbook contains at least one named range.
F4When 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.
F5Displays the GoTo dialog box.
F6Moves to the next item (worksheet, ribbon, task pane).
F7Displays the Spelling dialog box.
F8Toggles whether to extend a selection with the arrow keys. You will see the text "Extend Selection" appear in the status bar.
F9Smart 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.
F10Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.
F11Creates a chart (on a separate chart sheet) using the highlighted range as the data source.
F12Displays 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.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext