Note: The other languages of the website are Google-translated. Back to English
English English

How to display or hide Status bar in Microsoft Excel?

doc work area 1
With status bar
doc statu bar 2
Without status bar
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.
Display or hide status bar in Microsoft Excel with VBA
Display or hide status bar in Microsoft Excel with Kutools for Excel’s Work Area
Display or hide status bar in Microsoft Excel with Kutools for Excel' View options

arrow blue right bubble 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.


arrow blue right bubble 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.

Kutools for Excel, with more than 300  handy functions, makes your jobs more easier. 

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

Click Kutools > > Show & Hide > Work Area to enable Work Area Size utility. See screenshot:
doc kutools work area 1

Clicking this area to hide Status bar only
doc kutools work area 2

Clicking this area to hide both Status bar and Formula bar
doc kutools work area 3

Clicking this area to hide Status bar, Formula bar and Ribbon
doc kutools work area 4

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.

arrow blue right bubble Toggle work area



Kutools for Excel: 300 + functions you must have in Excel, 30-day free trial from here

arrow blue right bubble 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 > Show / Hide > View Options. See screenshot:
doc kutools view options 1

Step 2: In the View Options dialog box, check or uncheck the Status Bar option. See screenshot:
doc statu bar 3

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…

arrow blue right bubble Set Excel Options



Kutools for Excel: 300 + functions you must have in Excel, 30-day free trial from here

Relative Articles


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

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!
officetab bottom
Comments (11)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
very helpful, my status bar was missing but i got it back with hep of this article tahnk you so much
This comment was minimized by the moderator on the site
Thank you so much with the help of Macro code, my struggle ended to get status bar back. 
This comment was minimized by the moderator on the site
thank you! couldn't figure this out...
This comment was minimized by the moderator on the site
SO HELPFUL!Thanks for posting
This comment was minimized by the moderator on the site
Thank you! it really helps me to get the bar back.
This comment was minimized by the moderator on the site
This is extremely helpful as my status bar had disappeared for a reason I cannot identify. I haven't realized it before that this function is so essential for many tasks I have been performing everyday.
This comment was minimized by the moderator on the site
Thanks for the help! I used VBA instructions, it worked. :)
This comment was minimized by the moderator on the site
Thanks the VBA code worked like a charm!!! I have been looking for hours for this!
This comment was minimized by the moderator on the site
TYSM!! Awesome....more like this please :) helped no end....boss was puzzling for ages and really frustrated - thankfully i found this and solved his issue...lol he was even more baffled!
This comment was minimized by the moderator on the site
system had updated my excel and I lost my status bar - realised how often I used the quick sum, count, average, min, max until they disapeared! VBA solution worked a charm after wasting time looking for how to restore unsuccessfully
This comment was minimized by the moderator on the site
THANK YOU!!!...you just got +20 Karma
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations