Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Displaying Calculations with the Status Bar

You can simplify your work using the Status bar calculations when you don’t want to insert a formula, but you want to quickly see the results of a simple calculation. The Status bar automatically displays the sum, average, maximum, minimum, or count of the selected values. The Status bar results do not appear on the worksheet when printed but are useful for giving you quick answers while you work. If a cell contains text, it’s ignored, except when you select the Count option.

Calculate a Range Automatically

  • yellow-01.jpg Select the range of cells you want to calculate.
  • The sum, average, and count of the selected cells appears on the status bar by default.
  • yellow-02.jpg If you want to change the type of calculations that appear on the Status bar, right-click anywhere on the Status bar to display a shortcut menu.

    The shortcut menu displays all the available status information you can track. The right side of the menu displays the current values for the different calculations.

  • yellow-03.jpg Click to toggle (on or off) the available types of calculations.

    • Average
    • Count
    • Numerical Count
    • Minimum
    • Maximum
    • Sum
  • + Share This
  • 🔖 Save To Your Account