Fix Cut-Off Sum and Average Values on the Excel Status Bar
Question details
The user needs to see complete Sum and Average values on the Excel status bar.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- After a Windows or Office update, the user selects cells and checks their calculated values on the status bar.
- Observed behavior
- The last one or two digits of a status bar value are cut off.
Open a workbook and select several numeric cells so you can check the status bar after each change. Note your current Windows scaling and text-size settings so you can restore them if needed.
Adjust Windows display scaling and text size
Use this solution when status bar values are clipped after a Windows or Office update.
Open Start, select Settings, and go to System > Display.
Under Scale and layout, set Scale to 100%. On some Windows versions, this setting is labeled Make everything bigger.
In Settings, open Accessibility > Text size on Windows 11 or Ease of Access > Display on Windows 10. Move the text-size slider to its smallest setting and select Apply.
Open Start, select your account icon, and choose Sign out. Sign back in, open Excel, and select numeric cells to check whether the full values appear.

Check which Excel status bar calculations are enabled
Use this check if Sum or Average is missing from the status bar; enabling it alone may not fix clipped digits.
Update or repair Microsoft Office
Try an Office update or repair if the values remain clipped after adjusting Windows display settings.
Work with spreadsheet totals in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheets for a straightforward move from Office; it does not repair Excel's status bar.

Frequently Asked Questions
Why are the last digits of my Excel status bar total missing?
Windows display scaling or enlarged system text may cause the status bar value to be clipped. Check Settings > System > Display and the Windows text-size setting, then sign out and back in before testing Excel again.
How do I show Sum and Average on the Excel status bar?
Right-click the status bar at the bottom of Excel and select Sum and Average. Then select a range containing numeric cells.
Can I check the full total without using the status bar?
Yes. Enter a formula such as =SUM(A1:A10) in an empty cell, replacing the range with your data. Use =AVERAGE(A1:A10) to check the average.
What should I do if changing scaling does not fix the clipping?
In Excel, try File > Account > Update Options > Update Now. If the problem continues, close Excel and use the Modify option for Microsoft Office or Microsoft 365 in Windows Settings > Apps to run Quick Repair.




