Home
Office 2010 Tutorials
Excel 2010 Tutorials
Word 2010 Tutorials
PowerPoint 2010 Tutorials
Excel 2007 Tutorials
Word 2007 Tutorials
PowerPoint 2007 Tutorials
Video Training : Basic
Office 2007 Tips
Video Training : Tricks
Outlook 2007 Tutorials
Excel 2003 Tutorials
Word 2003 Tutorials
PowerPoint 2003 Tutorials
Outlook 2003 Tutorials
Office 2003 Ebooks
Free Office Templates
Free E-Books
Free Clip Arts
Free Newsletter
Free Tips and Tricks
Keyboard Shortcuts
Windows 7 Tutorials
Win Vista Training
MS Office - How To ?
Google Docs
MS Office Software
MS Publisher
Resources Page
Site Map
Contact Us
Privacy Policy

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines
 


Discover the Excel Automatic Calculation Capability!


Microsoft Excel Automatic Calculation feature is an extremely dynamic capability that by default automatically recalculates any changes you make to your Microsoft Excel worksheets.

Sometimes though you may find that due to the complexity and the size of your worksheet, you may want to control when the Microsoft Excel application recalculates your workbook or you may find that you just want a single worksheet to be recalculated.

To control the Excel 2003 Automatic calculation the worksheet, you must first turn the default automatic calculation function to manual.

To turn off the automatic calculation

  • From the Tools menu and select the Options command.
  • From the Options dialog box will displayed, select the Calculation tab.

    Excel options dialog box- Calculation tab



  • Under the Calculation section, select the Manual radio button.
  • Click the OK button.

    Once you are in manual calculation mode, there are two ways you can force the Microsoft Excel to recalculate.

    To use the automatic calculation feature

  • From the Tools menu and select the Options command.
  • From the Options dialog box will displayed, select the Calculation tab and then use either the Calc Now (F9) or Calc Sheet buttons.
  • To recalculate the entire workbook, click on the Calc Now (F9) button
    OR press F9 key.
  • Click on the Calc Sheet button will only update your current worksheet
    OR press Shift + F9.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    >> Next Topic : Copying Excel Worksheet from one Workbook to Another
    << Previous Topic : Using Excel RAND( ) Function to Generate Random Numbers


    You're viewing the Excel Automatic Calculation info page, click here to go back to the Home Page


    Microsoft Windows, Microsoft Office Word, Excel, PowerPoint, Access, OneNote,
    Outlook and Publisher are either registered trademarks or trademarks of
    Microsoft Corporation in the United States and/or other countries.

    Copyright © www.msoffice-tutorial-training.com All rights reserved.
    		•