Shift+F9: Calculate Active Worksheet

The shortcut Shift+F9 is to calculate the active worksheet in manual calculation model, please see (how to set calculation option to manual).

To calculate all worksheets in all open workbooks, please refer to the shortcut F9 to calculate all worksheets.

Step 1: Click the cell, e.g., Cell B3;

Step 2: Change the value in the cell from 4 to 6;

Step 3: Press and hold the "Shift" key, click the "F9" key to have the results.

Check More Excel Shortcuts

Leave a Reply