Office Settings & Configuration

Fix Cut-Off Sum and Average Values on the Excel Status Bar

Olivia MillerOlivia Miller Nov 22, 2026 868 views

Question details

The user needs to see complete Sum and Average values on the Excel status bar.

Fix Cut-Off 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.
Before you start

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.

Solution 1Recommended

Adjust Windows display scaling and text size

Use this solution when status bar values are clipped after a Windows or Office update.

1
Open display settings

Open Start, select Settings, and go to System > Display.

2
Test 100% scaling

Under Scale and layout, set Scale to 100%. On some Windows versions, this setting is labeled Make everything bigger.

3
Reduce system text size

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.

4
Sign out and test Excel

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.

Adjust Windows display scaling and text size
Adjust for readability: If text becomes too small in other apps, increase the scaling or text size gradually and retest Excel after each change.
Free Microsoft Office alternative

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.

Use spreadsheet formulas such as SUM and AVERAGE to check selected data.Open and edit compatible Microsoft Excel XLSX and XLS files.Navigate a familiar spreadsheet interface when moving from Microsoft Office.Use a free, lightweight office suite for everyday document work.
microsoft office alternative - wps office

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.