sodcalculator

10 Tech How-To

Excel Status Bar Missing? Fix It in 2 Minutes

Guide 10-30571 · Updated · Step by step

If your Excel status bar has disappeared, it is almost always because the status bar is hidden by the Windows taskbar, the Excel window is not maximized, or a display scaling issue is pushing it off-screen. The fix is usually as simple as pressing the F11 key or right-clicking the taskbar and selecting “Taskbar settings” to enable “Automatically hide the taskbar in desktop mode.” Below are the exact steps, plus how to restore individual status bar items like Sum and Average if they are missing.

Why the Status Bar Disappears

The status bar in Excel is the thin strip at the very bottom of the window that shows Ready, Sum, Average, Count, and other quick statistics. It is not a separate toolbar you can accidentally close—it is part of the Excel window itself. When it vanishes, one of three things is usually happening:

  • The Excel window is not maximized. If you drag the window down so the bottom edge is behind the Windows taskbar, the status bar is hidden.
  • The taskbar is set to auto-hide. When the taskbar auto-hides, it can cover the bottom of Excel until you move the mouse to the edge of the screen.
  • Display scaling is set above 100%. On high-DPI screens, Windows can misplace the Excel window, pushing the status bar off-screen.

In rare cases, a corrupted Excel add-in or a display driver issue can also cause the status bar to render incorrectly, but the above three are the most common culprits.

How to Bring the Status Bar Back

Try these fixes in order—each one takes less than a minute:

  1. Press F11 to make the Excel window full-screen. Press F11 again to return to normal view. This is the quickest test.
  2. Maximize the Excel window by clicking the square icon in the top-right corner, or double-click the title bar.
  3. Right-click the Windows taskbar and select Taskbar settings. Turn off Automatically hide the taskbar in desktop mode (and in tablet mode if applicable).
  4. Set display scaling to 100% temporarily: right-click the desktop, choose Display settings, and under Scale, set it to 100%. If the status bar reappears, the scaling was the issue—try a different scaling value like 125% or 150% that keeps the window fully on-screen.
  5. Reset Excel window position: close Excel, then reopen it. If it still does not appear, hold the Windows key + arrow keys to snap the window to the side and then maximize it.

If none of these work, the status bar may be hidden by a corrupt Excel state. Try restarting your computer, or run Excel in Safe Mode (hold Ctrl while starting Excel) to see if an add-in is interfering.

Missing Items in the Status Bar (Sum, Average, Count)

Sometimes the status bar is visible, but it only shows Ready and nothing else. That happens when you right-click the status bar and accidentally uncheck items like Sum, Average, or Count. To restore them:

  1. Right-click anywhere on the status bar (the bottom strip).
  2. A list of checkboxes appears—check Sum, Average, Count, Numerical Count, Minimum, Maximum, and anything else you want.
  3. Click anywhere outside the list to close it. The selected items will now appear whenever you select a range of numbers.

Note that these statistics only show when you select a range of cells. If you select a single cell, the status bar will only show Ready or Enter.

Status Bar vs. Formula Bar: What’s the Difference?

People often confuse the status bar with the formula bar. The formula bar is directly above the column letters and shows the contents of the selected cell. The status bar is at the very bottom of the window. If the formula bar is missing, you can bring it back by going to File > Options > Advanced and checking Show formula bar under the Display section. The status bar has no such checkbox—it is always part of the window, which is why the fixes above focus on window position and taskbar behavior.

Status Bar on Mac: Same Problem, Different Fix

If you are using Excel for Mac, the status bar is always visible at the bottom of the window, but it can be hidden if the window is not sized correctly. To bring it back:

  1. Click the green maximize button in the top-left of the Excel window.
  2. If that doesn’t help, go to View > Full Screen and then exit full screen (usually by pressing Esc).
  3. On macOS, the status bar can also be hidden if you are in Sheet View—go to View > Normal to return to the default view.

Mac users can also right-click the status bar to toggle items like Sum and Average, just like on Windows.

Common Misconceptions

One widespread myth is that the status bar is a separate toolbar that can be closed via the ribbon. That is false—the status bar is hardwired into the Excel window. Another misconception is that pressing Ctrl+Shift+U (which expands the formula bar) will bring back the status bar. It won’t—that shortcut only affects the formula bar. Also, some users think that hiding the ribbon (Ctrl+F1) hides the status bar. It doesn’t; the ribbon is at the top, the status bar at the bottom. If the status bar is missing, the issue is always with the window position or the taskbar, not with Excel settings.

Preventing Future Disappearances

To avoid this problem in the future:

  • Keep Excel maximized when you are working.
  • Avoid using auto-hide taskbar if you frequently work in full-screen apps.
  • If you use multiple monitors, make sure Excel is not spanning across two screens—drag it to one monitor and maximize.
  • Update your display drivers, especially if you have a high-DPI laptop.

If the status bar disappears repeatedly, check if a specific add-in is causing it. Disable all add-ins (File > Options > Add-ins > Manage COM Add-ins) and restart Excel. If the status bar stays, re-enable add-ins one by one to find the culprit.

Frequently Asked Questions

How do I restore the status bar in Excel if it’s completely gone?

Press F11 to toggle full-screen mode, or maximize the window. If that fails, right-click the Windows taskbar and turn off auto-hide. If the status bar still doesn’t appear, restart Excel or your computer.

Why does my Excel status bar only show “Ready” and not Sum or Average?

You need to select a range of cells that contain numbers. Right-click the status bar and make sure Sum, Average, and Count are checked. The status bar only shows these statistics when you have a selection.

Can I move the status bar to the top of the Excel window?

No, the status bar is fixed at the bottom of the Excel window. There is no setting to move it. If you want a quick view of sums, you can add a formula in a cell or use the Quick Analysis tool.

Does the status bar disappear in full-screen mode?

Yes, when you press F11 to enter full-screen, the status bar is hidden along with the ribbon. Press F11 again to exit full-screen and bring it back.

Why is my status bar missing only in one workbook?

It’s unlikely to be workbook-specific. The status bar is part of the Excel application, not the file. If it only appears missing in one workbook, check if that workbook has a custom view that hides the status bar (View > Custom Views). Delete the custom view to restore normal display.

How do I get the status bar back on Excel for Mac?

Click the green maximize button, or go to View > Normal. If that doesn’t work, quit Excel and reopen it. On Mac, the status bar is always part of the window, so if it’s missing, the window is likely not sized correctly.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →