The Excel status bar is the thin strip along the bottom of the Excel window, and it does instant maths on whatever cells you select. By default it shows the Average, Count and Sum, but you can right-click it to add Numerical Count, Minimum and Maximum. In current versions you can also click a result to copy it, so you rarely need a throwaway formula just to check a total.
What Is the Status Bar in Excel?
The status bar in Excel is the horizontal bar beneath the worksheet tabs that shows the current mode, quick calculations for selected cells, view buttons and the zoom slider. It updates the moment you change the selection, without writing anything into your workbook.
From left to right you will normally see:
- Cell Mode: Ready, Enter, Edit or Point, which tells you whether Excel is waiting for input or you are mid-way through editing a cell.
- Indicators such as Scroll Lock, Macro Recording or Fixed Decimal, when they are active.
- Summary calculations for the selected cells.
- View shortcuts for Normal, Page Layout and Page Break Preview.
- Zoom percentage and slider.
Which Calculations Can the Excel Status Bar Show?
The Excel status bar can show six calculations, but only three are turned on out of the box. Microsoft lists every option on its Excel status bar options page.
| Calculation | On by default? | What it shows | Equivalent formula |
|---|---|---|---|
| Average | Yes | Mean of the numeric cells selected | =AVERAGE() |
| Count | Yes | Number of non-empty cells, including text | =COUNTA() |
| Sum | Yes | Total of the numeric cells selected | =SUM() |
| Numerical Count | No | Number of cells that contain numbers | =COUNT() |
| Minimum | No | Smallest number in the selection | =MIN() |
| Maximum | No | Largest number in the selection | =MAX() |
The difference between Count and Numerical Count is the one people miss. Count includes text, so a column with a header and 50 values shows a Count of 51. Numerical Count ignores text, which makes it the better check when you want to know how many real numbers you have.
How Do You Add Hidden Calculations to the Status Bar?
You add the hidden calculations by right-clicking the status bar and ticking the ones you want. The change sticks for every workbook you open afterwards.
- Right-click anywhere on the status bar at the bottom of the Excel window.
- In the Customize Status Bar list, tick Numerical Count, Minimum and Maximum.
- Check that Average, Count and Sum are still ticked.
- Click anywhere outside the menu to close it.
- Select two or more cells containing numbers. All six results now appear on the right of the status bar.
The same menu controls indicators such as Caps Lock and Num Lock, which are off by default. Turning them on is handy on laptops without keyboard indicator lights.
Can You Copy a Value From the Excel Status Bar?
Yes. In Excel for Microsoft 365 on Windows and in Excel for the web, clicking a status bar value such as Sum copies it to the clipboard. You can then paste it into a cell, an email or a chat message.
- Select the cells you want to total.
- Click the Sum (or any other) value on the status bar.
- Click the destination cell and press Ctrl + V.
The pasted result is a fixed number, not a formula, so it won't update if the source cells change. Older perpetual versions such as Excel 2016 may not offer click-to-copy, which is one of the small quality-of-life gains in newer releases.
Why Is the Status Bar Sum Wrong or Missing?
The status bar sum is usually "wrong" because of how Excel reads the selected cells rather than a calculation error. These are the common causes:
- Numbers stored as text. Values imported from other systems are often text that looks like numbers. The status bar skips them, so Sum is too low and Numerical Count is smaller than Count. Look for the small green triangle in the cell corner and use Convert to Number.
-
Error values in the selection. If any selected cell contains an error such as
#N/Aor#DIV/0!, Excel can't total the range, so Sum and Average disappear and only the counts remain. Fix the errors or wrap the formulas inIFERROR. - Only one cell selected. Summary values appear only when two or more cells with numbers are selected.
- Hidden rows and columns. Hidden rows in the middle of a selection are generally left out of the totals, but hidden columns can still be included. To be sure, select the range, press F5 → Special → Visible cells only, then read the status bar.
- Calculations switched off. If the right side of the bar is empty, right-click it and make sure Sum, Average and Count are ticked.
If formulas in the sheet are not updating either, check Formulas → Calculation Options is set to Automatic.
What Do the Status Bar Indicators Tell You?
The indicators on the left explain several "Excel is broken" moments that are actually a mode being switched on.
- Scroll Lock: when on, arrow keys scroll the sheet instead of moving the active cell. Our guide to arrow keys not working in Excel covers how to switch it off on keyboards without a Scroll Lock key.
- Extend Selection or Add to Selection: shown after pressing F8 or Shift + F8. Every click extends the selection until you press the key again.
- Fixed Decimal: Excel is adding decimal places to every number you type, controlled from File → Options → Advanced.
- End Mode: the next arrow key jumps to the edge of the data block.
For more time-saving tricks of this kind, see our list of Microsoft Office productivity tips, or learn to keep headers visible with freezing the top two rows in Excel.
A Common Mistake We See
People often type a quick =SUM() next to their data just to check a total, then forget to delete it. The stray formula ends up in a shared file, gets included in a later total, and suddenly the figures don't reconcile.
The status bar gives you the same answer without touching the workbook. Turn on Numerical Count as well, and compare it with Count: if the two differ on a column that should be all numbers, you have text values hiding in your data before they cause trouble in a report.
Frequently Asked Questions
What is the status bar in Excel?
The status bar in Excel is the bar along the bottom of the window. It shows the cell mode, active indicators such as Scroll Lock, quick calculations for selected cells, view buttons and the zoom slider. You can customise which items appear by right-clicking it and ticking or unticking options.
How do I show the sum in the Excel status bar?
Select two or more cells containing numbers and the Sum appears on the right of the status bar. If it doesn't, right-click the status bar and tick Sum. If it still doesn't appear, check the selection for error values or numbers stored as text, which stop Excel showing a total.
Why does the Excel status bar only show Count?
Excel shows only Count when the selected cells contain text but no numbers, or numbers stored as text. It also drops Sum and Average when any selected cell contains an error value. Convert text to numbers or fix the errors and the full set of calculations reappears.
Can I add median or other functions to the status bar?
No. The Excel status bar offers six calculations only: Average, Count, Numerical Count, Minimum, Maximum and Sum. For median, standard deviation or anything else, use a formula in a cell, or the Quick Analysis button that appears at the bottom-right corner of a selected range.
Does the Excel status bar work in Excel 2024 and Excel 2021?
Yes. Microsoft's status bar options apply to Excel for Microsoft 365, Excel 2024 and Excel 2021, and the summary calculations exist in older versions too. Some options vary between versions, and click-to-copy is a newer feature, so check by clicking a value after selecting some cells.
Conclusion
The Excel status bar is the quickest way to total, average and count data without adding formulas, and turning on its hidden Minimum, Maximum and Numerical Count options makes it far more useful. If you are still on an older release, Office 2024 Professional Plus brings the current Excel with a one-time purchase; browse our Microsoft Office collection for other editions.
Useful Links
| Resource | Link |
|---|---|
| Microsoft Office licences | Microsoft Office collection |
| Office 2024 Professional Plus | Buy Office 2024 Pro Plus |
| Scroll Lock and arrow keys | Arrow keys not working in Excel |
| Office tips | Microsoft Office productivity tips |
| Status bar options (Microsoft) | Excel status bar options |
| Summary data (Microsoft) | View summary data on the status bar |
Leave a comment