Excel Status Bar Calculations
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:
- Select a range of cells in MS Excel.
- 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!
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.