How to Hide and Unhide Status Bar in Excel (2 Easy Methods)

The status bar in Excel serves as a dynamic interface element located at the bottom of the application window. It functions as a communication hub. The bar displays details ranging from the ready status of the application to specifics about the selected cells, such as counts, sums, and averages.

In this Excel tutorial, you will learn to hide and unhide the status bar.

The cause for hiding or unhiding the status bar in Excel mostly depends on the user’s preferences and specific needs. Mostly, users prefer to hide it for maximizing workspace and reducing distractions. Unhiding it shows summary and status information of data which can be a great help for users too.

Here is how the interface looks without any status bar.

status bar hidden

This is the view containing the status bar.

status bar showing

What Is Status Bar in Excel?

The status bar in Excel is the horizontal bar at the bottom of the window. It provides different useful information and shortcuts. You can modify the status bar information via mostly VBA and some built-in features.

status bar

The bar mostly consists of the cell mode indicator, worksheet view indicator, and zoom slider. It can contain other information such as accessibility status, macro recording status, fill handle options, etc. depending on the version and user settings.

2 Ways to Hide and Unhide Status Bar in Excel

If you truly want to hide/unhide the status bar, VBA is the way to go. However, different modes like full screen or focus mode can hide/unhide the status bar in Excel too.

You can hide and unhide the status bar in Excel, using these 2 methods:

Using VBA Code

You can use the Application.StatusBar property to display and hide information in the status bar. Setting this property to False or True hides and unhides the status bar.

You need to use the Developer tab to apply VBA codes in Excel. If you don’t see the tab, then you need to display the Developer tab on the ribbon in Excel.

To hide and unhide the status bar using VBA, follow these steps:

  1. Go to the Developer tab > Visual Basic.
    Applying VBA Code to Hide and Unhide Status Bar
  2. The VBA window will appear. Select Insert and then click on Module.
  3. Then copy this code and paste it into the module.
    Sub Show_sbar()
    Application.DisplayStatusBar = True
    End Sub
    Sub Hide_sbar()
    Application.DisplayStatusBar = False
    End Sub
  4. You need to save the Excel file using a macro-enabled extension or xlsm extension.
  5. Next, go back to the Excel interface and click on Macros in the Developer tab.
    Applying VBA Code to Hide and Unhide Status BarAs a result, a panel will appear named Macro and it will contain 2 sub-functions to hide and unhide the status bar.
  6. Choose the desired macro by name and press on Run.
    Within our code, Hide_sbar is the one for hiding the status bar and Show_sbar displays the bar.
    Applying VBA Code to Hide and Unhide Status Bar

The status bar will vanish/appear depending on the macro you have selected.
As we selected the Hide_sbar macro, the status bar is hidden in the figure below.

Toggling Between Full-Screen

The “Full Screen” of Excel offers the interface to provide a distraction-free and immersive working environment. It hides other Windows elements and some of the Excel elements. This includes the status bar.

The shortcut key to enter/exit the full screen is CTRL + Shift + F1. Pressing that will make both the ribbon and status bar disappear if you are entering the full screen.

The Excel window will look like this:

Using Keyboard Shortcuts

To find Ribbon in this mode, you can click the option on the top right corner of the Excel window.

You can press CTRL + Shift + F1 again to restore the previous interface.

There is a “Focus Mode” in Excel with a similar interface and interaction to the full-screen mode. This mode also hides the status bar. Press Alt+V then U on your keyboard to enter the focus mode. You can exit it by pressing Esc. This interaction will hide/show the status bar.

Download Practice Workbook

You can download the practice workbook from here.


Hiding or unhiding the status bar in Excel is a common topic in Excel. You can use VBA for that purpose. Also, you can toggle between screens to show or hide the status bar in Excel. If you’re still having trouble with any of these methods, let us know in the comments. Our team is ready to answer all of your questions.

Frequently Asked Questions

What does ‘Ready’ on the status bar mean in Excel?

‘Ready’ is the cell mode status displayed in the status bar. It indicates the general mode of a cell. When you press Enter, the status goes to “Edit” indicating the cell is in edit mode now.

Can I customize the status bar to show specific information for my workbook?

Yes, you can customize the status bar in Excel. To access the default option, right-click on the status bar and select the option you want to display. For more detailed customization, you need VBA.

How do I switch between Page Layout view and Normal view using the status bar?

There are buttons available for Normal view, Page Layout view, and Page Break view in the status bar beside the zooming options. You can click on them to switch between these views.

Related Articles

<< Go Back to Status Bar in ExcelExcel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nasir Muhammad Munim
Nasir Muhammad Munim

Nasir Muhammad Munim has been an Excel and VBA Content Developer for over a year in Exceldemy and published more than 30 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Electrical and Electronic Engineering from the Islamic University of Technology. Apart from creating Excel tutorials, he is interested in developing PostgreSQL, MySQL, and Android applications. He is fascinated by CAD-based designing systems and building... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF