How to Use Excel’s Status Bar (Tweak, Optimize, and Setup)

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Excel’s status bar is an interesting feature as it tells you different kinds of information.

What’s even cooler is that you can customize and tweak it to show the type of information you want.

In this article, you’ll learn about Excel’s status bar and how to use it.

Kasper Langmann, Co-founder of Spreadsheeto

Let’s get started!

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

What is Excel’s Status Bar?

The status bar in Excel is the little bar you see at the bottom of Excel’s window below the tab bars.

By default, it shows you the selected cells’ average, sum, and count.

You can also change from different workbook views from there and even change the zoom settings.

Here’s the status bar:

What is the status bar in Excel

That way, when you need to do a quick sum or an average, you can simply select the cells and see the results on the status bar.

Kasper Langmann, Co-founder of Spreadsheeto

How to customize the status bar

Not only will the status bar display the sum, average, and count, you can customize it to show you the information you need.

To customize the status bar, all you need to do is right-click on it.

How to customize the status bar

To enable an item, all you have to do is click on it.

For instance, you would like the status bar to show you if you’re on caps lock and num lock.

To do so, simply enable them on the status bar.

How to enable the caps lock and num lock on status bar

If I turn on caps lock and num lock on my keyboard, the status bar will let me know.

How the caps lock and num lock is displayed on the status bar

Nice! 👍

Can you remove the status bar?

Unfortunately, there’s no easy way to hide the status bar if you want to.

There used to be a way to do it in earlier versions of excel. However, it was removed in Excel 2007.

Kasper Langmann, Co-founder of Spreadsheeto

But if you really want to do it, you can do so by using an Excel VBA macro.

To do so, enable the ‘Developer’ tab first on Excel Options on the ‘Customize Ribbon’ tab.

How to enable the developer tab on the ribbon

Then, open the ‘Microsoft Visual Basic’ editor by clicking the ‘Visual Basic’ button on the developer tab.

How to add a visual basic code

Create a new module.

How to insert a new module in VBA

Finally, paste the code below into the window and press ‘Ctrl’ + ‘S’ on your keyboard to save the workbook with the code.

Sub HideStatusBar()
    Application.DisplayStatusBar = False
End Sub
What code to use to hide the status bar

On the worksheet, click ‘Macros’ on the ‘Developer’ tab and run the code.

How to run a macro in Excel

After that, you will no longer see the status bar.

How Excel looks like without a status bar

Awesome! 😄

Wrapping things up…

Excel’s status bar is a nice feature that would enable you to see basic information about your workbook. It also provides easy access to zoom features and even to workbook views.

As you can see, customizing the status bar is super easy. After right-clicking on it, you will see all the various information that the status bar could display. All that’s left is for you to enable it. 😉

Kasper Langmann, Co-founder of Spreadsheeto