Excel Guides

Disappearing Status Bar in Excel

If you're experiencing a disappearing status bar in Excel, there are a few possible explanations.

One possibility is that the status bar is turned off. To check if this is the case, go to File > Options > Advanced. Under Display options for this workbook, look for Show status bar. If it's unchecked, check it and click OK. This should make the status bar reappear.

Another possibility is that your worksheet is too small to display the status bar. To fix this, try increasing the size of your worksheet. You can do this by going to File > Page Setup > Sheet and changing the values under Print titles.

If neither of these solutions works, it's possible that your status bar has been customized and is now hidden. To check if this is the case, go to File > Options > Customize Ribbon. Under Main Tabs, look for the Developer tab. If it's checked, click OK. This will add the Developer tab to your ribbon, which you can use to access the Visual Basic Editor. In the Visual Basic Editor, go to Tools > References and look for Microsoft Excel Object Library. If it's not checked, check it and click OK. This will add a reference to the Excel object library, which you can use to access the status bar.

Once you've added the reference, go back to the Visual Basic Editor and select Insert > UserForm. This will insert a new UserForm into your workbook. In the UserForm code window, paste the following code:

Private Sub UserForm_Initialize()

    Dim myStatusBar As StatusBar

    Set myStatusBar = Application.StatusBar

    myStatusBar.Visible = True

End Sub

This code will make the status bar visible when you open your workbook.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.