|
Excel: AutoCalculate
Using AutoCalculate for quick calculations
If you thought AutoSum was great then you will really appreciate Excel's AutoCalculate feature! When you need to perform a quick calculation on a range of selected cells AutoCalculate is for you. Once a range of cells is selected the sum of those values automatically appears in Excel's status bar. A simple right-click in the AutoCalculate area of the status bar provides other functions such as Min, Max, Average, and Count. Read on for the instructions.
Instructions for AutoCalculate
- Select the range for calculation
- Look in the status bar for the calculation (see Figure 1).
Changing the Function for AutoCalculate
- Select the range of cells for calculation
- Right-click the status bar area containing the calculation
- Click the desired function
Note to Excel 2003 Users:
Once you change the function of AutoCalcuate that will be the function Excel uses the next time you select a range of numbers. Simply right-click the status bar to pick a different function.
Note to Excel 2007 Users:
Excel 2007 allows for display of all the functions listed in the AutoCalculate list. Simply right-click the status bar for a list of status bar options and click on the functions you want to display in the status bar at all times. In the future when you select a range of values you will see all the calculations performed by the functions you have displayed in the status bar.
Have a great week!
|
