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

While working on Excel we often face the problem that our status bar has been disabled accidentally or want to hide the status bar while working on a small screen. So we might want to hide or unhide the status bar according to our needs. In this article, we will learn how to hide/unhide the status bar in Excel.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Methods to Hide and Unhide Status Bar in Excel

Excel gives us the facility to hide/unhide the status bar from the built-in option and do it manually from developer options as well. Here is the step-by-step procedure of both of these methods.


1. Applying VBA Code to Hide and Unhide Status Bar

We can also hide or unhide the status bar in excel using VBA codes and running the sub-programs. Here are the steps to do so.

Steps:

  • Firstly, we need to go to the Developer tab in Ribbon and select Visual basic.

Applying VBA Code to Hide and Unhide Status Bar

  • Secondly, a window will appear where we need to find Insert and then click on Module.

  • Thirdly, we need to copy this code and paste it under the General section in the window.
Sub Show_sbar()
Application.DisplayStatusBar = True
End Sub
Sub Hide_sbar()
Application.DisplayStatusBar = False
End Sub
  • Then we need to save the excel file using a macro-enabled extension or xlsm extension.

  • Next in the Developer tab, we need to click on Macros.

Applying VBA Code to Hide and Unhide Status Bar

  • As a result, a panel will appear named Macro and it will contain 2 sub-functions to hide and unhide the status bar.

  • Furthermore, we can choose any of these options and then press on Run. Let’s say we want to hide our status bar. We will select Hide_sbar and then press Run.

Applying VBA Code to Hide and Unhide Status Bar

  • In the end, we can see our status bar has vanished like in the image below.


2. Using Keyboard Shortcuts

We can use a keyboard shortcut to hide and unhide the status bar in excel. To do this method, all we need to do is press CTRL+Shift+F1. Pressing that will disappear the Ribbon and status bar. The excel window will look like this.

Using Keyboard Shortcuts

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

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


3. Utilizing Excel Options

For this method to work, we need older versions of Microsoft Excel. The procedure is given below.

Steps:

  • At first, we need to go to Options in the File menu or in the Excel launch window.
  • After that, we need to find the Advanced option in the Excel Options dialog box.
  • Finally, we need to scroll down in the Display options for this workbook. Here we will find an option named Show Status bar. Tick or untick this option to hide and unhide the status bar.

Things to Remember

  • If we use VBA to hide the status bar, we need to use VBA again if we want to unhide.
  • Using the keyboard shortcut method will hide the Ribbon as well.

Conclusion

Hiding or unhiding status bar in Excel is a common topic in Excel. This article will help you in that purpose. 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. For any excel related problems, you can visit our website Exceldemy for all types of excel related problem solutions.

Nasir Muhammad Munim

Nasir Muhammad Munim

I am Nasir Muhammad Munim from Dhaka, Bangladesh. I work as an Excel and VBA Content Developer for Exceldemy right now. Electrical and electronic engineering was my major at Islamic University of Technology, where I got my degree. I love creative works and learning new things. And I'm really into online games, especially first-person shooter games.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo