How to display or hide Status bar in Microsoft Excel?
With status bar
Without status bar
Display or hide status bar in Microsoft Excel with VBA
Display or hide status bar in Microsoft Excel with Kutools for Excel' View options
Display or hide status bar in Microsoft Excel with Kutools for Excel’s Work Area
Work Area |
| Kutools for Excel's Work Area can help you to quickly change working area size by hiding formula bar, status bar or ribbon. |
Recommended Productivity Tools
Office Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Kutools for Excel: 200 new features for Excel, make Excel much easy and powerful, increase productivity immediately.
Display or hide status bar in Microsoft Excel with VBA
If you are experienced with using Microsoft Excel, a VBA macro will help you display or hide status bar in Microsoft Excel easily.
Step 1: Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.
Step 2: Click Insert > Module, and paste the following macro in the Module Window.
VBA for displaying status bar in Microsoft Excel
Sub Show_Status_Bar()
Application.DisplayStatusBar = True
End Sub
VBA for hiding status bar in Microsoft Excel
Sub Hide_Status_Bar()
Application.DisplayStatusBar = False
End Sub
Step 3: Press the F5 key to run this macro. And you will get the result that you want.
Display or hide status bar in Microsoft Excel with Kutools for Excel's View Options
If you are not familiar with VBA macros, the following method will be better. Kutools for Excel's View Options tool can help you display or hide status bar in Microsoft Excel with only mouse clicking.
| Kutools for Excel, with more than 120 handy functions, makes your jobs easier. | ||
After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)
Step 1: Click the Kutools > Show / Hide > View Options. See screenshot:
Step 2: In the View Options dialog box, check or uncheck the Status Bar option. See screenshot:
If you want to show the status bar in Microsoft Excel, check the Status Bar option; If you want to hide the status bar in Microsoft Excel, please uncheck the Status Bar option.
The View Options of Kutools for Excel makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … etc. It will save your time in looking for these setting when you need to show or hide them. Click to know more…
Display or hide status bar in Microsoft Excel with Kutools for Excel’s Work Area
If you want to quickly toggle display and hide Status bar in Excel window, Kutools for Excel’s Work Area utility can do a favor for you.
After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)
Click Kutools > Work Area to enable Work Area Size utility. See screenshot:
Clicking this area to hide Status bar only
Clicking this area to hide both Status bar and Formula bar
Clicking this area to hide Status bar, Formula bar and Ribbon
If you want to display all bars, just click the Kutools > Work Area again to recover the window.
 Kutools for Excel: The 200 functions you must have in Excel, you can free download from here |
Recommended Productivity Tools
Office Tab
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Kutools for Excel
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
200 New Features for Excel, Make Excel Much Easy and Powerful:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...
