Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Reply
Views: 769 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
  #1  
Old 01-26-2010, 09:49 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default Topic 27: Discover the Excel Automatic Calculaion 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.


Reply With Quote
  #2  
Old 01-26-2010, 09:50 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default

Under the Calculation section, select the Manual radio ****on.
Click the OK ****on.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 ****ons.

To recalculate the entire workbook, click on the Calc Now (F9) ****on
OR press F9 key.Click on the Calc Sheet ****on will only update your current worksheet
OR press Shift + F9.
Reply With Quote
Reply

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.