Tuesday, November 23, 2004

MS Excel:Turn the Auto calculation- ON and OFF

You may temporarily want to turn off the automatic calculation option while working with large worksheets in Microsoft Excel. This allows you to enter all the formulas without having to wait for a recalculation. To do this:

  • Open the Tools menu and click Options.
  • In the Options dialog box, click the Calculations tab.
  • Then, click on the radio button labeled Manual, and click OK to close the dialog box.
  • If you want to check a calculation while you are working, simply press F9.

When you finish a large worksheet, don’t forget to turn automatic calculation back on.

No comments: