ExtendOffice - Professional Add-ins and Tools for Microsoft Office
fackbook twitter

How to display or hide Status bar in Microsoft Excel?


With status bar

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' View options
Display or hide status bar in Microsoft Excel with Kutools for Excel’s Work Area good idea3

Insert Blank Rows & Columns(insert multiple blank rows/columns at once, or insert blank rows/columns every nth row/col...)

doc insert blank row

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.

formula Never need to worry about long long formulas in Excel anymore! Kutools for Excel's Auto Text can add all formulas to a group
as auto text, and liberate your brain! Click here to know Auto Text     Click here to get free trial

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 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 Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

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…

If you are interested in this addi-in, click here to download the 60-days free trial.

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 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

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

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

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

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

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

pay attention1If you are interested in this addi-in, download the 60-days free trial.

good idea4Split Workbook

Kutools for Excel's Split Workbok help you split all sheets from a workbook and save them as separate workbooks, texts, csv files or pdf files.
doc split workbook


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 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...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Add comment


Security code
Refresh