Microsoft Excel is a spreadsheet application included in the Microsoft Office Suite. Excel automatically recalculates cell values whenever a worksheet is modified. This can be a hindrance, especially if you need to make many updates to a large spreadsheet which takes a long time to recalculate. In this case, it may be beneficial to turn off calculations while you update the spreadsheet. When you are finished updating the values, turn calculations back on to recalculate the cell values.
- Skill level:
Other People Are Reading
Open Microsoft Excel and click "Formulas" in the Ribbon at the top of the Excel window.
Click "Calculation Options" on the far right side.
Select "Manual" to disable auto-calculation. If you want Excel to recalculate your spreadsheet while auto-calculation is disabled, you will need to click "Calculate Now," also located under "Calculation Options." When you are ready, you can re-enable auto-calculation.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for