How to Make Excel Spreadsheet Recalculate Real Time Automatically Instead of Pressing F9 (3 Steps)

By Vee Enne

Microsoft Excel spreadsheets are composed of small blocks called cells. Each cell in a spreadsheet can contain a formula, data or a blank value. Formulas use commands like "SUM" and "COUNTA" to consolidate information or to make calculations and return a value. If your spreadsheet is set up for manual calculations, you must press F9 each time you want to recalculate the formulas. To have the spreadsheet update automatically in real time, you can set it to "Automatic."

Step 1

Open an Excel file in which you'd like to make changes. Click the "Formulas" tab.

Step 2

Click "Calculation Options."

Step 3

Select "Automatic."