Shift + Function
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. |
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext