How to Fix an Excel Total That Is Cut Off (Displaying ####)
Question details
The user needs to fix an Excel cell containing a total that is visually truncated or displaying as a string of hash symbols (####).

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Viewing or calculating numerical totals in a spreadsheet where the final number does not fit or display correctly within the cell.
- Observed behavior
- The cell containing the calculated total either visually cuts off the number or replaces the numeric value entirely with ####.
Click on the affected cell and check the Formula Bar at the top of your screen to verify that the correct total is actually being calculated behind the scenes before making visual adjustments.
AutoFit or Widen the Column
The most common reason numbers display as #### or get cut off is that the column is too narrow to accommodate the entire value.
Find the lettered column header (e.g., A, B, C) at the top of the column that contains your cut-off total.
Hover your cursor over the right boundary line of the column header until it turns into a double-sided arrow, then double-click. Excel will automatically resize the column to fit the largest number.
Alternatively, click and hold the right boundary line, then drag it to the right until the full total appears.

Adjust the Number Format
Sometimes unnecessary decimal places or large formatting symbols cause the number to overflow the cell bounds.
Enable Shrink to Fit
If you are working with strict layout requirements and cannot widen the column, you can force the text to shrink to fit the current cell size.
Fix Cut-Off Totals Easily with WPS Spreadsheet
WPS Office provides an intuitive and free Spreadsheet tool perfectly compatible with Microsoft Excel files. You can effortlessly adjust column widths, format numbers, and calculate totals without display errors.
- 1. Open your file: Launch WPS Spreadsheet and open the document containing the cut-off totals.
- 2. Select the column: Click the column letter at the top to highlight the entire column.
- 3. AutoFit to display totals: Double-click the right boundary of the column header to automatically expand the width to fit your totals perfectly.

Frequently Asked Questions
Why does Excel show #### instead of my calculated total?
Excel intentionally displays #### when a column is too narrow to show an entire numeric value or date. This prevents users from seeing a partial number, which could cause significant miscalculations if misread.
Can a formula error cause a total to be cut off?
Yes. If an incorrect formula results in an exceptionally large number or an unformatted date sequence, it might exceed the standard cell width. Always check the Formula Bar to verify what result the formula is generating.
How do I fix a cut-off total in a PivotTable?
Right-click anywhere inside your PivotTable and select 'PivotTable Options'. On the 'Layout & Format' tab, make sure the box for 'Autofit column widths on update' is checked. This ensures the columns widen automatically when totals increase.




