Excel Status Bar Calculations

Dennis Faas's picture

You do not always need a formula in MS Excel. That's right, you can just look at the Status bar to view a quick calculation.

On the right-hand of the Status bar, at the bottom of the Excel screen, calculations can be displayed for the average, count, number or numbers, maximum/minimum value, and sum of any given range of numbers.

Follow the steps below to see how:

  1. Select a range of cells in MS Excel.
     
  2. In Excel version 2003, right-click on the Status bar, where you see the calculation listed, and choose the function to be performed.

In Excel version 2007, look toward the bottom of your screen. You do not need to click, but if you do, you will see additional options appear.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

| Tags:
Rate this article: 
No votes yet