What Is a Status Bar in Excel
The status bar is the thin horizontal strip running along the very bottom of the Excel window, just below the worksheet tabs and the horizontal scroll bar. It quietly displays the current mode (Ready, Enter, or Edit), instant statistics for whatever cells you have selected, the view-switching buttons, and the zoom slider — all without you clicking into a menu.
It is on by default, and you can right-click it to turn individual readouts on or off. Below we cover what every item means on both Windows and Mac, how to customize the bar, and how to fix it when the numbers vanish or the bar disappears entirely.
What the Status Bar Is and Where to Find It
In any modern version of Excel — Microsoft 365, Excel 2021, 2019, 2016, and Excel for Mac — the status bar spans the full width of the window at the very bottom. Do not confuse it with the sheet tabs just above it or the formula bar at the top; the status bar is strictly the bottom-most strip.
It splits into three rough zones. The left side shows the cell mode and indicators such as Caps Lock or macro recording. The center shows the AutoCalculate statistics for your selection. The right side holds the view shortcut buttons and the zoom controls. Everything is optional except the mode indicator, which always stays put.
AutoCalculate: Instant Stats for a Selection
The single most useful feature of the status bar is AutoCalculate. Select two or more cells that contain numbers and Excel instantly shows summary statistics in the center of the bar — no formula required. It is the fastest way to sanity-check a column.
By default Excel shows the Sum, Average, and Count of the selection. You can switch on three more: Numerical Count, Minimum, and Maximum. Here is what each reports:
| Status bar item | What it shows |
|---|---|
| Average | The arithmetic mean of the numeric cells in the selection |
| Count | The number of selected cells that are not empty (includes text and dates) |
| Numerical Count | The number of selected cells containing numbers only |
| Minimum | The smallest numeric value in the selection |
| Maximum | The largest numeric value in the selection |
| Sum | The total of all numeric cells in the selection |
These readouts are display-only — they update live as you change your selection but never write anything into the sheet. When you need the result inside a cell, reach for the matching function instead: the SUM function to add numbers, a quick way to get a total in Excel, the formula to calculate an average, or COUNT to tally entries. The status bar is the preview; the function is the permanent record. In newer builds you can click a readout to copy its value to the clipboard.
View Shortcuts and the Zoom Slider
On the right side of the status bar sit three small view buttons that switch how the sheet is laid out on screen:
- Normal — the standard grid view you work in most of the time.
- Page Layout — shows the sheet as printed pages, complete with margins, headers, and footers.
- Page Break Preview — shows where pages will break, with draggable blue lines so you can fine-tune the layout before printing. This pairs well with the way you set a print area in Excel.
To the right of those buttons is the zoom control: a percentage readout and a slider with minus and plus buttons. Drag the slider, click the buttons, or click the percentage to open a dialog with preset levels. The default zoom is 100%. If you prefer more precise control, the full set of options for zooming in and out in Excel covers keyboard and ribbon methods too.
Mode and Indicator Items
The left end of the status bar reports the cell mode, the current state of the active cell:
- Ready — Excel is idle and waiting for input.
- Enter — you are typing new content into a cell.
- Edit — you are editing existing cell content (press F2 to enter Edit mode).
- Point — you are selecting a cell or range to feed into a formula you are building.
Beyond the mode, the status bar can surface several indicators when you switch them on: Caps Lock, Num Lock, and Scroll Lock light up when those keys are active, Macro Recording shows a button while a macro records, and a Calculating message appears while large workbooks recompute. Scroll Lock is a common culprit when arrow keys scroll the whole sheet instead of moving the cursor — if that happens, see how to turn off Scroll Lock in Excel.
How to Customize the Status Bar
You decide which items appear. The control is the same on every platform:
- Right-click anywhere on the status bar. A long menu called Customize Status Bar opens.
- Each row has a checkmark on the left. Click an item to toggle it on or off — for example, switch on Minimum, Maximum, and Numerical Count, or hide Average if you never use it.
- Notice that each row also shows its current value on the right, so you can see at a glance what is active.
- Click anywhere outside the menu to close it. Your choices stick for future sessions.
There is no way to reorder the items — Excel fixes their positions — but you can show or hide any of them freely. If you work heavily from the keyboard, knowing these toggles complements the broader set of Excel keyboard shortcuts for moving and selecting fast.
The Status Bar on Mac
Excel for Mac has a status bar too, and it behaves much like the Windows version: Control-click it to open the Customize Status Bar menu, and the AutoCalculate stats, view buttons, and zoom slider all work the same way.
The main difference is that some indicators are absent on Mac. Because macOS handles keyboard state differently, the Caps Lock, Num Lock, and Scroll Lock readouts do not appear in the Mac menu. The cell-mode indicator, AutoCalculate stats, view shortcuts, and zoom controls are all present, so the experience is nearly identical — you just will not find the lock-key toggles.
Troubleshooting the Status Bar
The status bar is missing entirely
If the whole strip has vanished, it is almost always hidden rather than broken. On Windows, maximize or resize the Excel window — a window dragged below the screen edge can push the bar out of view. Full-screen mode (View tab) can also hide it; press Esc or toggle full-screen off. On Mac, check the window is not extending past the bottom of the display. The bar cannot be permanently disabled, so resizing nearly always restores it.
Sum, Average, or Count is not appearing
Two things to check. First, the readout may simply be switched off — right-click the status bar and make sure Sum, Average, and Count have checkmarks. Second, AutoCalculate only shows statistics when your selection contains numbers. If your “numbers” are actually stored as text (left-aligned, sometimes with a green triangle in the corner), Sum and Average will not appear even though Count does. Convert the text to real numbers and the stats return. Remember that AutoCalculate needs an active selection of at least one numeric cell — click into a blank area and the numbers naturally disappear.
I can’t see the view buttons or zoom slider
These live on the far right of the status bar, so they are the first things to get clipped when the window is narrow. Widen the Excel window and they reappear. If they are still missing on a wide window, right-click the status bar and confirm that Zoom, Zoom Slider, and View Shortcuts are checked in the Customize Status Bar menu — any of the three can be toggled off independently.
Frequently Asked Questions
What is the status bar in Excel?
The status bar is the horizontal strip at the very bottom of the Excel window. It shows the current cell mode (Ready, Enter, Edit), instant statistics such as Sum and Average for your selected cells, the Normal/Page Layout/Page Break Preview view buttons, and the zoom slider. It is on by default and gives you quick information without opening a menu.
Why is the status bar missing in Excel?
A missing status bar is usually hidden rather than disabled. It is most often pushed off-screen by a window dragged below the display edge, or hidden by full-screen mode. Maximize or resize the Excel window, and press Esc to exit full-screen if needed. Excel does not offer a setting to remove the status bar permanently, so resizing the window almost always brings it back.
How do I customize the Excel status bar?
Right-click anywhere on the status bar to open the Customize Status Bar menu. Click any item to toggle it on or off — for example, switch on Minimum, Maximum, and Numerical Count, or hide readouts you do not use. Each row shows its current value next to it. Click outside the menu to close it; your choices persist. You cannot reorder items, only show or hide them.
How do I show the sum in the status bar?
Select two or more cells that contain numbers and the sum appears automatically in the center of the status bar. If it does not show, right-click the status bar and make sure Sum is checked. Also confirm the values are real numbers and not text — if Count appears but Sum does not, your figures are likely stored as text and need converting.
Why is Sum or Average not showing in the status bar?
The two common causes are a hidden readout or non-numeric data. Right-click the status bar to confirm Sum and Average are checked, then verify your cells hold actual numbers, not text — text values are left-aligned and may carry a small green triangle. AutoCalculate also needs an active selection with at least one numeric cell, so the stats vanish in an empty area.
Does the Excel status bar work the same on Mac?
Mostly yes. Excel for Mac shows the same AutoCalculate stats, view buttons, and zoom slider, and you customize it by Control-clicking the bar. The difference is that the Caps Lock, Num Lock, and Scroll Lock indicators are absent on Mac because macOS reports keyboard state differently.
