Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
As the name suggests status bar displays the status in the bottom right corner of Excel, it is a customizable bar which can be customized as per the user’s needs, by default the status bar has page layout and setup view available it and to customize it we need to right-click on the status bar and we will find various options.
Status Bar in Excel (Table of Contents)
What is Status Bar in Excel?
In Microsoft, every application has a status bar which is on the bottom of the window which displays a range of options. In every application of Microsoft, there is a parent bar which has all the other options of file insert etc and a status bar which is on the far bottom of the window.
Just Like any other window application Excel also has its own status bar which is on the bottom of the parent window.
Refer to the screenshot below,
With the help of status bar, we can have a quick view of various things such as average, sum, minimum and maximum etc.
For a layman, person status bar is very helpful as a person need not know the excel equations for calculating various calculation and just have a quick view while looking just at the status bar.
Status Bar can also be customized, just right click on the status bar and click on the options we need to have some quick view about it.
In the above screenshot currently, Average Count Sum and other options are checked.
How to Use Status Bar in Excel? (with Examples)
Let us learn the use of Status Bar by a few examples.
Status Bar in Excel Example #1
Consider a user has following data,
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.
- Select the marks i.e. cell B2:B7.
- Now have a look at the status bar, it shows us the sum of the marks and average of the marks, as in our status bar we had this option checked.
- Now while looking at this status bar, User can input the values of the average marks and total marks.
- Let us calculate the average and sum by the formulas to check whether the values shown by the status bar is correct or not.
- Write sum function in cell C8, write down =sum( and select the range B2:B7, and press enter.
- Also in cell C9 write =Average( and select the range B2:B7 and press Enter.
- We can check that the values shown in the status bar are absolutely correct.
Status Bar in Excel Example #2
Consider the following data,
This 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 are done by them in any month. Let us find out.
- To know the total sales are done by Anand Select cell B2:D2 and see the status bar.
- Now let us calculate the total sales done in the January Month. Select Cells B2:B6 and see the status bar.
- Let us find out the average sales done in all the months combined. Select Cells B2:D6 and look at the status bar.
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.
Status Bar in Excel 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.
- To Enable Maximum and Minimum in the status bar, right click on the status bar and the customize dialog box appears.
- Click on Minimum and Maximum and a tick mark appears which shows that these options have been enabled.
- Now we have the option enabled of minimum and maximum, select the data i.e. B2:B7.
- Now if we look at the status bar we can see that it also shows what is the maximum value and minimum value selected.
Status Bar in Excel 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 own convenience.
Consider the following same data,
- There is a zoom slider in the bottom right of the status bar.
- If we click on the plus sign it zooms the text in the worksheet.
- For Example, take it to 150% and have a look at the data.
- Now decrease it to 85% and have a look at the data.
- Any user can increase or decrease the size of the data. Well, the usual normal size is 100%.
Explanation of Status Bar in Excel
- As described earlier, with a status bar, we can have a quick view of various things such as excel average, sum, minimum and maximum etc.
- For any easy user, the status bar is very helpful as a user need not to know the formulas for calculating various calculation and just have a quick view while looking just at the status bar.
- Status Bar can also be customized, just right click on the status bar and click on the options we need to have some quick view about it.
Things to Remember
- Select the appropriate options to view like, sum, average, minimum, maximum.
- To customize the data right click on the status bar.
- To view any status we desire we need to select the range of data.
This has been a guide to Status Bar in Excel. Here we discuss how to customize and uses Status Bar in Excel with practical examples and downloadable excel template. You may learn more about excel from the following articles –