Fix a Cut-Off Sum Value in the Excel Status Bar
Question details
The user needs to see the complete Sum value for a selected range in the Excel status bar.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Selecting a range of numeric cells to check its Sum in the status bar.
- Observed behavior
- The last digit of the Sum may be clipped. Toggling status bar calculations can temporarily restore it, but the clipping may return when another range is selected.
Select a range containing numeric values and check the Sum at the bottom of the Excel window. If the status bar is crowded, note which other calculations are displayed.
Toggle the Excel Status Bar Calculations
Use this quick workaround to refresh the Sum display when its last digit is clipped.
Right-click the status bar at the bottom of the Excel window to open Customize Status Bar.
Click Sum to turn it off, then right-click the status bar again and click Sum to turn it back on. You can also toggle Average or other calculation options.
Select a different range of numeric cells and check whether the complete Sum is visible.

Check Display Settings and Update Excel
Try these checks if toggling the status bar options does not keep the Sum visible.
Check Spreadsheet Sums with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. It supports Microsoft Excel formats, making it easy to move existing workbooks into WPS and check selected cell values.

Frequently Asked Questions
How do I show Sum on the Excel status bar?
Right-click the status bar at the bottom of Excel and select Sum. Then select a range containing numeric values.
Why does the last digit disappear again after I select another range?
Toggling Sum may refresh the display only temporarily. Try resizing the Excel window and checking display scaling, resolution, Office updates, and the graphics driver.
Can I make more room for the Sum on the status bar?
Right-click the status bar and turn off calculations you do not need, such as Average or Count. You can also maximize the Excel window.
How can I check the total if the status bar is still clipped?
Enter a SUM formula in an empty cell, such as =SUM(A1:A10), using the range you want to total. The result appears in the cell.




