How to Use the Status Bar within the Excel 2013 Platform

show more Using the Status bar provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training show less
please wait ...

Using the Status bar

The Status Bar located below the sheet tabs, at the bottom of the screen, often contains the word "Ready" in the lower left-hand corner. If you're entering a data you'll see the word Enter there, but many, many other indicators can appear in the Status Bar. Off to the right, you will see three buttons for different kinds of use, Normal, Page Layout, and Page Break Preview. To the right of that, you'll see a Zoom Slider Bar. We might want to zoom in on this worksheet to see the data large and clear that way, or may want to zoom back and see more data, although not nearly as large.

As we do different things using Excel, other indicators might pop-up as well. I might be typing and might want to use the Caps Lock Key and I'll click it, or maybe I did that by mistake. In the lower left-hand corner, we see the term "Caps Lock". As you select the data, now, I might be interested in the revenue, the total revenue here and by clicking Column I, suddenly quite a few numbers appear at the bottom of the screen. I know immediately the total revenue here for 2012 is over $22 million and it's showing me the maximum, the minimum, account of how many entries, and the average and quite a few bits of information that I'm really interested in.

If you highlight two or more cells in Excel, you will see at the bottom of the screen some of these indicators. Although possibly, you could have turned them off. If you click with the right mouse button anywhere in the Status Bar, you will see a rather large selection of check boxes with a number of features here. You want to explore these from time to time. If you want to be notified, if you accidentally clicked the Num Lock Key, then turn that check box on. The numbers that I just referred to at the bottom of the screen here are in this section right here--do you find these valuable? You might leave them all checked and then over time say, "you know, I don't use Count very much, I don't need that".

We won't see them at the bottom of the screen as we highlight data. I'd say leave them on for awhile and then come back and explore this every so often. Think about how handy it is when you're looking in a large list here. If you know your data well enough, if there's nothing else in the column. How many items did we sell this year? We'll click column H, and we sold -- and it's kind of hard to read without commas, but how many items did we sell? 389,000 items, so it's a handy feature. The Status Bar gives us a lot of good information, and from time to time, do right-click on it and consider which of these options, which of these indicators you do want to have active.

Using the Status bar
Video duration: 2m 24s 6h 32m Appropriate for all


Using the Status bar provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2013 Essential Training

Business Education + Elearning
please wait ...