Excel Status Bar Calculations
by Carol Bratt on January, 22 2008 at 08:01AM EST
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!
Filed under:
Rate this article:
Free Guide
Most popular articles
- Which Processor is Better: Intel or AMD? - Explained
- How to Prevent Ransomware in 2018 - 10 Steps
- How to Fix: Computer / Network Infected with Ransomware (10 Steps)
- How to Fix: Your Computer is Infected, Call This Number (Scam)
- Scammed by Informatico Experts? Here's What to Do
- How to Fix: Windows Update Won't Update
- Explained: Do I need a VPN? Are VPNs Safe for Online Banking?
- Forgot Password? How to: Reset Any Password: Windows Vista, 7, 8, 10
Do you need Tech Support?
I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.
I can help! Send me a message on the bottom left of the screen (using the Zopim Chat button), or click my picture to read more about how I can fix your computer over the Internet. Optionally you can read all about my credentials, here.