Skip to main content

How to display or hide Status bar in Microsoft Excel?

Author: Kelly Last Modified: 2024-08-28

Does the status bar disappear from Microsoft Excel's window by accident? Do you want to hide the status bar in Microsoft Excel? The following tricks will help you quick display or hide status bar in Microsoft Excel.

With status bar
a screenshot showing status bar in Excel
Without status bar
a screenshot without Status Bar in Excel

Display or hide status bar in Microsoft Excel with VBA
Easily display or hide status bar in Microsoft Excel with Kutools for Excel’s Work Area
Easily display or hide status bar in Microsoft Excel with Kutools for Excel' View options


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 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 > > View > Work Area to enable Work Area Size utility.

Clicking this area to hide Status bar only
a screenshot of selecting the Hide status bar icon to hide the status bar

Clicking this area to hide both Status bar and Formula bar
a screenshot of selecting the Hide status bar and formula bar icon to hide both the status bar and the formula bar

Clicking this area to hide Status bar, Formula bar and Ribbon
a screenshot of selecting the Hide status bar, formula bar and ribbon icon to hide the status bar, formula bar and the ribbon

If you want to display all bars, just click the Kutools > Work Area again to recover the window.

Tip. If you want to have a free trial of the Work Area function, please go to free download Kutools for Excel first, and then go to apply the operation according above steps.


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.

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

Step 1: Click the Kutools > View > View Options.

Step 2: In the View Options dialog box, check or uncheck the Status Bar option. See screenshot:
a screenshot of unchecking the Status Bar option in the View Options dialog box

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…


Relative Articles


Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!