How to Adjust the Status Bar in Excel

The status bar in Excel is a horizontal bar located at the bottom of the Excel window. It displays information about the active cells, such as the average, count, sum, and other statistics such as standard deviation, median, and mode. The status bar displays basic information by default, but you can customize it to display the information that you need.

Understanding the Status Bar

This example demonstrates a table that displays the sales volumes of products categorized into two groups.

Excel status bar table

To quickly find out the total or average sales and how much has been sold, you can use the SUM, AVERAGE, and COUNT formulas. However, it is faster to simply look at the status bar at the bottom of the screen. The status bar shows the total, average, and count of the selected cells, and it ignores empty cells.

Excel Status Bar

Average, Count and Total are the standard settings of the status bar, but you can change them by right-clicking on the status bar. At this moment you are only interested in the options marked in the figure below a red frame.

Excel customize Status Bar

Customizing the Status Bar

Let’s add Minimum and Maximum to the information displayed on the status bar. Now five additional information will be given the status bar.

Excel status bar customized

Note that all calculations are made without blank cells. For example, if you delete data for 4 products that failed to sell, the average will be 17 for the remaining 6 products. The minimum sale will be 2.
Excel Status Bar calculations

See also  How to create Tables in Excel

To avoid such problems for products that failed to sell, enter zero. In the figure below, the correct values are calculated, the average is 12 and the minimum 0.

Excel Status Bar calculations

Adjusting the status bar in Excel is a simple process that allows you to customize the information displayed in the status bar. By selecting the statistics that you want to display, or by using a formula or macro, you can easily access the information that you need to effectively manage your data.