Status Bar in Excel

Excel has so many unique features that sometimes, some of the features don’t get the credit they deserve.

One such tool is the Status Bar in Excel.

The Status Bar, as the name suggests, allows us to check the status of a few things (such as the cell mode or the macro recording status, or the Accessibility status).

It also has options that allow us to quickly zoom in and zoom out in the worksheet or change the Workbook view. You can also configure it to show common calculations such as SUM or AVERAGE of a dataset when you select a range of cells in the worksheet.

Knowing how to use the status bar properly can help you become much more efficient when working with Excel.

In this tutorial, I will tell you everything you need to know about the status bar, starting with the fundamental question – “Where is the status bar in Excel?”

Where is the Status Bar in Excel?

You will find the status bar below the worksheet area in the Excel workbook (below the sheet tab names).

Status Bar in Excel

Excel does not allow you to change the position of the status bar, so you should always see the status bar in the same position.

Status Bar Not Showing – What to Do?

Although uncommon, there is a possibility that the status bar in your Excel is not showing.

Try the below keyboard shortcut to see if it sorts the issue:

CONTROL + SHIFT + F1

The above shortcut toggles in and out between the full-screen mode.

So if the full-screen mode is enabled on your system, you won’t be able to see the status bar, and using the above keyboard shortcut would bring you out of the full-screen mode, which should make the status bar visible again.

Another possible reason for the status bar not showing in Excel could be a conflict with an add-in. So if you are using any add-in, try disabling it and see if it solves the problem.

Here is some discussion about how to get the status bar back in case it disappears.

Default Options in the Status Bar in Excel

Now let me take you through the different options that are available in the status bar and what they mean.

Cell Mode

On the left-most side of the status bar, you’ll see some text written (such as Ready or Edit or Enter).

cell mode in the status bar in Excel

This tells you the cell mode based on the status of the active cell.

Let me quickly take you through the cell modes Excel has and the text you will see in the status bar for each mode.

Ready

When you see the Ready mode in the status bar, it means that the worksheet is now ready for you to do the work.

Ready mode in the status bar in Excel

It also means that nothing else is going on in your worksheet, and you can go ahead and start the work.

Edit

When you see the edit mode in the status bar, it means that your cursor is within a cell, and the cell is in the edit mode, where you can enter data or formulas or edit the existing cell content.

Edit mode in the status bar in Excel

So when you see the Edit mode, it means that the cell is being edited.

Enter

Enter mode is also like the Edit mode, with a tiny difference.

Enter mode in the status bar in Excel

When you are in the Edit mode and you use the arrow keys, it is going to move the cursor within the cell itself. But when you are in the Enter mode, and you press the arrow keys, it is going to move to the cells in the direction of the arrow key.

You get into the Enter mode when you select a cell and press the F2 key twice or you double click on the cell.

Point

You will see the Point mode in the status bar when you enter a formula in a cell, and then you select any other cell that you want to use as a reference in that cell.

Point mode in the status bar in Excel

Macro Recording Icon

Just next to the cell mode, you have the macro recording icon in the status bar.

Macro Recording icon in status bar

When you click on the macro recording icon, it opens the Record Macro dialog box where you can specify the name of the macro and some description and start recording the macro.

While the macro is being recorded, you will notice that the icon in the status bar changes into a transparent square, and you can stop recording the macro by clicking on this record macro icon.

Also read: How to Record a Macro in Excel

Accessibility Check

Next to the record macro icon, you will see the accessibility check option (which tells you whether the workbook accessibility is good or not). This is Microsoft’s initiative to make sure that everyone can work with the Excel workbooks, including people with disabilities.

accessibility good to go in Excel

If there are any accessibility issues in your workbook, you will see the text ‘Accessibility: Investigate’ in the status bar.

accessibility investigate in Excel

And when you click on it, it is going to open the Accessibility pane on the right that will guide you on how to make your workbook accessible to everyone.

accessibility pane in Excel

And if there are no issues, you will see the text ‘Accessibility: Good to Go’

Workbook Views

On the right side of the status bar, you have three Workbook Views icons (Normal, Page Layout, and Page Break Preview):

  • Normal View – This is the view that you usually see when you open an Excel workbook (hence called Normal)
  • Page Layout View – Page Layout view is helpful when you want to see how your work would look when printed. It shows you the start and end row and column for each page as well as the headers and footers (if added)
  • Page Break Preview – If you have added any page breaks in your worksheet, you can use the Page Break Preview option to see where these would appear when you print your worksheet
Workbook views in the status bar

Note that you can also get these options in the ‘View’ tab in the ‘Workbook View’ group.

Zoom-in Zoom-Out Icons and Zoom Slider

To the right of the workbook views icons, you will find the zoom option-related icons.

Zoom Slider

Using the zoom slider, you can manually change the zoom levels of the worksheet.

Zoom slider in status bar

By default, the zoom slider is in the middle at a 100% zoom level. If you move the slider to the left, it is going to zoom out (so you will see more rows and columns), and if you move the slider to the right, it is going to Zoom-in the worksheet.

Note that you can zoom between 10% and 400% in Excel

Zoom In and Zoom out icon:

On either side of the zoom slider, you also have the zoom-out and zoom-in icons.

Zoom in and Zoom out icon in status bar

Clicking on these icons would change the zoom level by 10%.

Zoom Level

At the right end of the status bar, you have the zoom level (that shows the current zoom value of the worksheet).

Zoom level in status bar

When you click on the zoom level option, it is going to open the Zoom dialog box where you can select from any of the pre-existing options, or you can manually specify the zoom setting you want for the worksheet.

Zoom dialog box Excel

Data Stats for the Selected Range

When you select a range of cells in the worksheet, it is also going to show you some statistics about that selected range in the status bar.

By default, it shows the Sum, Count, and Average values for the selected range.

average count and sum value in the status bar

In case you select a range of cells that contains only text data, it is only going to show you the count of the cells.

Customizing the Status Bar

While the Excel team has tried to show some of the useful information in the status bar by default, it also allows you to customize the status bar, where you can choose to show more or less information.

Below are the steps to customize the status bar in Excel:

Step 1 – Right-click anywhere on the status bar

Step 2 – In the Customize Status Bar options that open, you can select any option that doesn’t have the green tickmark next to it to make it available in the Status bar. Alternatively, if you click on any of the options that already have the green tick mark, the green tick will be removed, and that option will not be shown in the status bar.

customized status bar options

As you will notice, most of the Customize Statusbar options are already enabled (and have the green tick on the left).

Let me quickly cover ones that you can consider enabling for the status bar:

Workbook Statistics

When you enable the Workbook Statistics option in the customized status bar menu, you will notice that this option also appears in the status bar (next to the Cell Mode).

workbook statistics option in the status bar becomes visible

And when you click on this option in the status bar, it is going to open the workbook statistics dialog box that is going to show you some statistics about the current sheet and the workbook.

workbook statistics dialog box

Sheet Number

If you work with Excel workbooks that have a lot of worksheets, you may want to enable the Sheet Number option in the Customize Status bar menu.

sheet number option enabled in status bar

Once this is enabled, you will see the current sheet number in the status bar (as shown below)

sheet number shows up in the status bar
Also read: Count Sheets in Excel (using VBA)

Caps Lock / Num Lock / Scroll Lock

When you enable the Caps Lock, Num Lock, and Scroll Lock options for the status bar, it will be shown in the status bar in case these are enabled.

CAPS lock scroll lock and num lock in status bar

For example, below, I have the screenshot where I have enabled all these three options to be shown in the status bar and have also activated them.

Note: The Scroll Lock option is activated by default to be shown in the status bar

Also read: How to Turn OFF Scroll Lock in Excel?

Maximum / Minimum Value in the Selected Range

When you select a range of cells in a worksheet, the status bar automatically shows you the data, such as sum, count, and average.

enabling maximum and minimum values from a data range

You can further customize and add more data to it or remove the existing ones.

Apart from the Sum, Count, and Average, you can add Numeric Count, Maximum, and Minimum values.

Note: Status bar is also available in other Microsoft applications such as MS Word and PowerPoint. While the options would be different based on the application, you can use the same steps shown here to customize the status bar

Other Excel articles you may also like:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment