What is the Status Bar in Excel?

In Microsoft, every application has a status bar at the bottom of the window, which displays various options. In addition, in every application of Microsoft, there is a parent bar with all the other options of the “File,” “Insert,” etc., and a status bar on the far bottom of the window.

Like any other window application, Excel has its status bar at the bottom of the parent window.

Refer to the screenshot below,

With the help of the status bar, we can quickly view various things such as average, sum, minimum, maximum, etc.

For a layman, the person’s status bar is very helpful as a person need not know the equations in excelEquations In ExcelIn Excel, equations are the formulas we type into cells. We begin by writing an equation with an equals to symbol (=), which Excel knows as calculate.read more for evaluating various calculations and have a quick view while looking just at the status bar.

We can also customize the status bar. Please right-click on the status bar and click on the options we need to view quickly.

The above screenshot currently checks the average count, sum, and other options.

How to Use Status Bar in Excel? (with Examples)

Let us learn the use of the status bar by a few examples.

Example #1

We will consider that the user has very little knowledge about the formulas to calculate the total marks and the average marks scored by the student in his exams.

Example #2

Consider the following data,

  • First, select the marks, which is cell B2:B7. Now, have a look at the status bar. It shows us the sum and average of the marks, as we had this option checked in our status bar. Now, while looking at this status bar, the user can input the average and total marks’ values. Let us calculate the average and sum by the formulas to check whether the values shown by the status bar are correct or not. Insert the SUM function in cell C8, write down =SUM(select the range B2:B7, and press the “Enter” key.) Also, in cell C9 write =AVERAGE( select the range B2:B7 and press the “Enter” key). We can check that the values shown in the status bar are correct.

It is the data for sales done by the employees of a company. Suppose the boss is having a quick look at the raw data and wants to know the sales done by each employee either in total or in a respective month or the total sales made by them in any month. Let us find out.

  • To know the total sales made by Anand, select cell B2:D2 and see the status bar.

  • Now, let us calculate the total sales done in January. So, choose cells B2:B6 and see the status bar.

  • Let us find out the average sales done in all the months combined. Then, select cells B2:D6 and look at the status bar.

The status bar not only shows the sum and average or the count of selected cells. It does even show more, which we will learn in further examples.

Example #3 – Customize Status Bar

Consider the following data, which shows the total sales done by the employees of a company.

Suppose we want to know the minimum and maximum sales done.

  • Step 1: Enable maximum and minimum in the status bar, right-click on the status bar, and the customize dialog box appears.

  • Step 2: Click on “Minimum” and “Maximum.” A tick mark appears, showing that these options have been enabled.

  • Step 3: Now, we have the minimum and maximum options enabled. Select the data, B2:B7.

  • Step 4: Now, if we look at the status bar, we can see that it also shows the maximum value and minimum value selected.

Example #4 – Zoom Option

One of the very useful tools in the status bar is the zoom option. It allows the user to zoom in or zoom out the data for a better view. Any user can adjust it according to their convenience.

Consider the following same data,

  • Step 1: There is a zoom slider in the bottom right of the status bar.

  • Step 2: If we click on the “plus” sign, it zooms the text in the worksheet.

  • Step 3: For example, take it to 150% and have a look at the data.

  • Step 4: Now, decrease it to 85% and look at the data.

  • Step 5: Any user can increase or decrease the data size. Well, the usual normal size is 100%.

Things to Remember

  • We must select the appropriate options to view like, sum, average, minimum, and maximum.To customize the data, we must right-click on the status bar.We must select the range of data to view any status we desire.

This article has been a guide to Status Bar in Excel. Here, we discuss how to customize and use the status bar in Excel with practical examples and a downloadable Excel template. You may learn more about Excel from the following articles:-

  • VBA Status BarCalculate Age in ExcelCalculate Age In ExcelIn Excel, the DATEDIF and TODAY functions can be used to calculate age. The DATEDIF function accepts three arguments: the year, the month, and the day.read moreFractions in ExcelFractions In ExcelFractions in excel are number formats where the fractions are displayed as the actual fractions rather than the decimals. It could be accessed from the format tab of the excel and then from the category list you can choose fraction.read moreChecklist in Excel?Checklist In Excel?In Excel, a checklist is a checkbox that represents whether or not a given task has been completed. Normally, the value returned by the checklist is either true or false, but we may improvise the results. For example, when the checklist is ticked, the result is true; when it is blank, the result is false. The insert option on the developer’s tab allows you to insert a checklist.read moreLinear Programming in ExcelLinear Programming In ExcelLinear programming in excel helps implement this applied mathematics aspect to excel worksheet for solving business problems through resource optimization. For this purpose, the user can opt for the “Excel Solver”.read more