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

Chapter 3. Working with Formulas and Fun... > Displaying Calculations with AutoCal...

Displaying Calculations with AutoCalculate

You can simplify your work using a feature called AutoCalculate when you don't want to insert a formula, but you want to see the results of a simple calculation quickly. Auto-Calculate automatically displays the sum, average, maximum, minimum, or count of the selected values on the status bar. Auto-Calculate results do not appear on the worksheet when printed but are useful for giving you quick answers while you work.

Calculate a Range Automatically

Select the range of cells you want to calculate.

The sum of the selected cells appears on the status bar next to SUM=.

If you want to change the type of calculation AutoCalculate performs, right-click anywhere on the status bar to open the AutoCalculate sub menu.

Click the type of calculation you want.

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