Shift + Function

Shift + F1Redundant see last table below.
Shift + F2Inserts or edits a cell comment.
Shift + F3Displays the Insert Function dialog box (can be used from the formula bar).
Shift + F4Repeats the last Find. Selects the next empty cell on the right inside the used range of the active worksheet.
Shift + F5Displays the Find and Replace dialog box with the Find tab active.
Shift + F6Moves to the previous item (worksheet, ribbon, task pane).
Shift + F7Displays the Thesaurus task pane.
Shift + F8Toggles between switching Add Mode on or off. This allows you to select non contiguous blocks of cells using the keyboard arrow keys. You will see the text "Add to Selection" appear in the status bar.
Shift + F9Smart Recalculation. Calculates the Active / Selected worksheets in the Active workbook.
(only cells containing formulas that have changed since the last calculation will be updated).
Shift + F10Displays the Shortcut menu for the selected item.
Shift + F11Inserts a new worksheet (before the active sheet) into the active workbook.
Shift + F12Saves. Displays the Save As dialog box when its a new workbook.
Shift + F1
Redundant see last table below.
Shift + F2
Inserts or edits a cell comment.
Shift + F3
Displays the Insert Function dialog box (can be used from the formula bar).
Shift + F4
Repeats the last Find. Selects the next empty cell on the right inside the used range of the active worksheet.
Shift + F5
Displays the Find and Replace dialog box with the Find tab active.
Shift + F6
Moves to the previous item (worksheet, ribbon, task pane).
Shift + F7
Displays the Thesaurus task pane.
Shift + F8
Toggles between switching Add Mode on or off. This allows you to select non contiguous blocks of cells using the keyboard arrow keys. You will see the text "Add to Selection" appear in the status bar.
Shift + F9
Smart Recalculation. Calculates the Active / Selected worksheets in the Active workbook.
(only cells containing formulas that have changed since the last calculation will be updated).
Shift + F10
Displays the Shortcut menu for the selected item.
Shift + F11
Inserts a new worksheet (before the active sheet) into the active workbook.
Shift + F12
Saves. Displays the Save As dialog box when its a new workbook.

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