spot_img

Status Bar

 

Status Bar 101 | Customize Status Bar | Status Bar Secrets

The status bar in Excel can be quite useful. By default, the status bar at the bottom of the window displays the average, count and sum of selected cells.

Status Bar 101

The status bar in Excel can do the math for you.

1. Select the range A1:A3.

Select Range

2. Look at the status bar to see the average, count and sum of these cells.

Average, Count and Sum

3. To quickly change the workbook view, use the 3 view shortcuts on the status bar.

View Shortcuts

Note: visit our page about workbook views to learn more about this topic.

4. Use the zoom slider on the status bar to quickly zoom in or out to a preset percentage.

Zoom Slider

Note: use the ribbon to zoom to a specific percentage or to zoom to a selection.

Customize Status Bar

Many status bar options are selected by default. Right click the status bar to activate even more options.

1. Right click the status bar.

2. For example, click Caps Lock.

Customize Status Bar

Note: this doesn’t turn on Caps Lock (see image above, Caps Lock is still turned off). The status bar displays the Caps Lock status now.

3. Press the Caps Lock key on your keyboard.

4. Excel displays the text Caps Lock in the status bar.

Status Bar in Excel

5. Right click the status bar.

6. For example, click Minimum.

Click Status Bar Option

7. Select the range A1:A3.

Select Range

8. Look at the status bar to see the average, count, minimum and sum of these cells.

Added Status Bar Option

Status Bar Secrets

Here’s a little secret: Excel uses the status bar in many other situations. If you don’t like this, hide the status bar.

1. For example, filter a table.

Filtered Table

2. Excel uses the status bar to display the number of visible records.

Status Bar Message

3. Hover over a cell with one or more comments.

Comments

4. Excel uses the status bar to display the name of the author.

New Status Bar Message

5. If you have Excel 2016, use the shortcut CTRL + SHIFT + F1 to hide the ribbon and the status bar.

6. To only hide the status bar, add the following code line to the Workbook Open Event:

Application.DisplayStatusBar = False

7. Use the StatusBar property in Excel VBA to display a message on the status bar.

StatusBar Property in Excel VBA

Note: if you’re new to Excel, you can skip step 6 and step 7.

spot_img
Previous articleCapital Investment in Excel
Next articleActiveX Controls in Excel VBA