• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 19. Copying Formulas and Recalcul... > Controlling When Your Worksheet Is R...

Controlling When Your Worksheet Is Recalculated

Excel recalculates the formulas in a worksheet every time you edit a value in a cell. However, on a large worksheet, you may not want Excel to recalculate until you have entered all of your changes. For example, if you are entering a lot of changes to a worksheet that contains many formulas, you can speed up the process by changing from automatic to manual recalculation. To change the recalculation setting, take the following steps:

  1. Open the Tools menu and choose Options.

  2. Click the Calculation tab to display the options shown in Figure 19.2.

  3. Select one of the following Calculation options:

    Automatic. This is the default setting. It recalculates the entire workbook each time you edit or enter a formula.

    Automatic except tables. This automatically recalculates everything except formulas in a data table. You'll learn about data tables (databases) in Lesson 28.

    Manual. This option tells Excel to recalculate only when you say so. To recalculate using this option, you press F9 or choose Tools, Options, Calculation and click the Calc Now (F9) button. When this option is selected, you can turn the Recalculate before save option off or on.

  4. Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint