Ctrl+Alt+Shift+F9: Calculate All Cells

The shortcut Ctrl+Alt+Shift+F9 is to check dependent formulas, then calculate all cells in all open workbooks (see how to set Calculation Option to Manual).

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 Ctrl, Alt and Shift keys, click the F9 key to have the calculated results.

Check More Excel Shortcuts

Leave a Reply