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.
- Firstly, we need to go to the Developer tab in Ribbon and select Visual basic.
- 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.
- 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.
- 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.
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.
- 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.
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.