Get Quick Answers Using Excel’s Status Bar
By on August 17th, 2011

There is hardly any debate to the fact that Excel is an extremely powerful tool. It can do complex formulas and calculations at mind-numbing speed. All this being said, however, in all the years I have worked in IT, I have observed that most people use it for a basic set of functions. I believe that Microsoft recognized this as well. They made it very easy for us to get answers to our common questions. The problem is, they put this tool in an uncommonly used place. Today, I would like to introduce you to Excel’s “Status Bar” and to show you how it can make your life a little easier.

What is a status bar you ask? Well, it is way down at the bottom of the screen. You know, the place that no one hardly ever looks. In the picture below, you can see Excel’s main window with the status bar highlighted.

Main Window

Several things happen in the status bar that often go unnoticed. For instance, when you hit the “Caps Lock” key on your keyboard, an indicator shows up in the status bar. It is also home to some pretty helpful tools that can help you get quick answers from your spreadsheet.

Let’s begin by selecting a column of numbers like the ones pictured below. One of the most common tasks in a spreadsheet is to sum up a column of numbers. Notice that Excel makes this very easy. Below, you will see what the status bar shows when you have a column of numbers highlighted. By default, Excel shows you the average, sum, and count of the selected numbers.

Status Bar

If you right-click the status bar, you will get a context menu which will allow you to customize which fields you need displayed.  In the picture below, you can see the different options that you have. Notice the red circled area. Here, you can add other popular functions to the status bar.

Customize

Let’s add minimum and maximum to the status bar and see what we get. If you highlight your data as pictured below, you now will notice that the status bar gives some additional information. Highlighted below, you can see the “Min” and “Max” functions. Sometimes it is nice just to be able to glean out what the smallest and largest numbers in a spreadsheet are. The status bar makes this very simple to find.

Min Max

I hope this tutorial helps to simplify some of the common tasks you perform in Excel. Of course, if you enjoy typing “=Sum(H1:K8)” every time you want to get a Sum in a column, then this tip probably isn’t for you. ;)

Let me know what you think about this tip. I love questions and comments.

Tags: , , ,
Author: Darrin Jenkins Google Profile for Darrin Jenkins
Darrin is an IT manager for a large electrical contractor in Louisville KY. He is married and has 3 kids. He loves helping people with their technology needs. He runs a blog called Say Geek!

Darrin Jenkins has written and can be contacted at darrin@techie-buzz.com.
  • http://techie-buzz.com/how-to/get-quick-answers-using-excels-status-bar.html Hal

    How does one get the status bar Average to not round? If the Sum of 2 numbers is 53 I want the Average to show 26.5, not 27.

    Thanks!

    • http://saygeek.blogspot.com/ Darrin Jenkins

      Sorry I just saw this comment. What type of number are you using? It doesn’t round on mine.

  • LC

    I tried the right click on the status bar but don’t see the options you showed above to customize status bar. I used to have it, but I must have clicked on something and the sum disappeared. I have an Apple laptop. Thank you!

    • Darrin Jenkins

      Is this Office 2010.

  • LC

    It’s Microsoft Excel X for Mac Service Release 1. I hope this is what you need to know. Thanks!

 
Copyright 2006-2012 Techie Buzz. All Rights Reserved. Our content may not be reproduced on other websites. Content Delivery by MaxCDN