How to Turn Off Calculations in Excel 2010

Written by amanda rumble
  • Share
  • Tweet
  • Share
  • Email

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:
Easy

Other People Are Reading

Instructions

  1. 1

    Open Microsoft Excel and click "Formulas" in the Ribbon at the top of the Excel window.

  2. 2

    Click "Calculation Options" on the far right side.

  3. 3

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.