Excel Status Bar: Customize & Use It Effectively

The status bar in Microsoft Excel is the thin strip at the very bottom of the window. It shows useful information like the average, count, and sum of selected cells, plus quick toggles for views and zoom. This guide shows you how to read it, customize what appears, and fix it when it’s not showing what you expect.

What You’ll Need

• A computer with Microsoft Excel installed (this works for Excel 2016, 2019, 2021, and Microsoft 365)
• A spreadsheet with some numbers in it to test the status bar features

Step-by-Step

Part 1: Understanding the Default Status Bar

1. Open Excel and look at the bottom of the window. You’ll see the status bar. On the left, it usually says “Ready” or “Enter” depending on what you’re doing.
2. Select a range of cells that contain numbers. For example, click and drag from A1 to A5 if those cells have numbers.
3. Look at the right side of the status bar. You should see three numbers: Average, Count, and Sum. These update automatically based on what you select.
4. Try selecting text cells or a mix of text and numbers. The Count will show how many cells have data, while Average and Sum only appear if there are numbers.

Part 2: Adding and Removing Items from the Status Bar

1. Right-click anywhere on the status bar. A context menu appears with a long list of options.
2. Look for checkmarks. Items with a checkmark next to them are currently visible. Items without one are hidden.
3. Click any item to toggle it on or off. For example, click “Minimum” and “Maximum” to add those to the display. You’ll now see them when you select numbers.
4. Add “Numerical Count” if you want to know how many cells contain numbers specifically, as opposed to the regular Count which includes text.
5. Click “Cell Mode” to show or hide the “Ready” / “Edit” indicator on the left side.
6. Close the menu by clicking anywhere else on the screen. Your changes save automatically.

Part 3: Using Status Bar Features

1. Zoom slider: On the far right of the status bar, you’ll see a minus sign, a slider, a plus sign, and a percentage. Drag the slider or click the +/- buttons to zoom in and out of your worksheet.
2. View shortcuts: Next to the zoom slider, there are three small icons. These switch between Normal view, Page Layout view, and Page Break Preview. Click each one to see the difference.
3. Selection count: If you select multiple cells, the status bar shows “Count: 10” or similar. This is useful for quickly counting non-empty cells.
4. Sum with a twist: If you want a different calculation, right-click the status bar and check “Sum,” “Average,” “Min,” “Max,” or “Count.” You can have all of them visible at once.
5. Keyboard shortcuts: Press Ctrl+Shift+U to expand or collapse the formula bar. This doesn’t affect the status bar directly, but it changes the layout above it.

Part 4: Advanced Status Bar Options

1. Caps Lock indicator: Right-click the status bar and check “Caps Lock.” Now when Caps Lock is on, you’ll see “Caps Lock” appear on the status bar. This is handy if you have a keyboard without an indicator light.
2. Signatures and permissions: These options show icons when a workbook has digital signatures or restricted access. You can keep them off unless you work with protected files.
3. Fixed decimal: If you enable this, Excel will automatically insert a decimal point when you type numbers. The status bar will show “Fixed Decimal” so you remember it’s on.
4. Overtype mode: This toggles between Insert and Overtype modes. When Overtype is on, the status bar shows “Overtype” instead of “Ready.”

Common Mistakes

• Selecting empty cells: If you select blank cells, the status bar might show “Count: 0” or nothing at all. Make sure you’re selecting cells with data.
• Expecting Sum on text: The Sum, Average, Min, and Max only work with numeric values. If your selection includes text, those calculations will be ignored for text cells.
• Hiding everything: If you right-click and uncheck all items, the status bar becomes nearly empty. You can always right-click again to re-enable them.
• Confusing Count with Numerical Count: Count includes all non-empty cells (text and numbers). Numerical Count only counts cells with numbers. They will differ if you have mixed data.
• Not realizing the status bar is there: Some users accidentally hide the entire status bar by entering full-screen mode (Ctrl+Shift+F1). Press that shortcut again to bring it back.

Tips

• Keep Sum, Average, Count, Min, and Max all visible. They give you instant statistics without writing a single formula.
• Use the status bar to check for errors. If you select a range and the status bar shows “Count” but no “Sum,” it might mean some cells contain text instead of numbers.
• Customize per session. Your status bar settings persist across Excel sessions, but if you share a computer, someone else might change them. Re-check your preferences when you start a new project.
• Double-click the zoom percentage to open the Zoom dialog box for precise control.
• Use the status bar to see the average of a filtered list. When you filter data, the status bar calculations only apply to the visible (filtered) cells, not the hidden ones.

Troubleshooting

• Status bar is completely missing: This usually means Excel is in full-screen mode. Press Ctrl+Shift+F1 to toggle it back. If that doesn’t work, go to File > Options > Advanced and look under “Display” to ensure “Show status bar” is checked (if that option exists in your version).
• No Sum/Average appears when selecting numbers: Right-click the status bar and make sure “Sum” and “Average” are checked. If they are checked but still not showing, try selecting a different range of cells that definitely contain numbers.
• Status bar shows wrong values: This can happen if you have hidden rows or columns. The status bar only calculates visible cells. Unhide rows/columns to include them, or use the SUBTOTAL function for more control.
• Zoom slider is missing: Right-click the status bar and check “Zoom Slider.” If it’s already checked, try restarting Excel.
• Caps Lock indicator not showing: Right-click the status bar and ensure “Caps Lock” is checked. If it still doesn’t appear, your keyboard might not send the correct signal to Excel, which is rare.
• Status bar freezes or stops updating: This is often a temporary glitch. Save your work, close Excel, and reopen it. If it persists, check for pending updates to Office.

Frequently Asked Questions

Why does my status bar not show the sum of my selected cells?

The Sum option is probably turned off. Right-click the status bar and put a checkmark next to “Sum.” Also, make sure the cells you selected contain numbers, not text.

Can I make the status bar show a custom message?

No, Excel doesn’t allow custom text on the status bar. It only shows built-in indicators and calculations. You could use a cell comment or a text box for custom notes.

How do I get the status bar back after full-screen mode?

Press Ctrl+Shift+F1 to exit full-screen mode. This keyboard shortcut toggles between showing and hiding the ribbon and status bar.

Does the status bar work with filtered data?

Yes. When you filter a table or range, the status bar calculations (Sum, Average, Count, etc.) only consider the visible rows. This is a quick way to get subtotals for filtered data.

Can I change the order of items on the status bar?

No. The status bar has a fixed layout. You can only show or hide items, not rearrange them. The order is determined by Excel.

Why does the status bar show “Enter” instead of “Ready”?

That means you are in the middle of entering data into a cell. Press Enter, Esc, or click another cell to return to “Ready” mode.

Related

• Install Fossil Version Control on Linux
• Restore Xiaomi Laptop to Factory Settings If It Won’t Start
• Windows 11 Shared Folder Access Error: Fixes