How to Make Excel Spreadsheet Recalculate Real Time Automatically Instead of Pressing F9

Save

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."

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

  • Click "Calculation Options."

  • Select "Automatic."

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!