Formatting Issues

How to Fix an Excel Total That Is Cut Off (Displaying ####)

Elise WilliamsElise Williams Nov 3, 2026 870 views

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 (####).

How to Fix an Excel Total That Is Cut Off
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 ####.
Before you start

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.

Solution 1Recommended

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.

1
Locate the column header

Find the lettered column header (e.g., A, B, C) at the top of the column that contains your cut-off total.

2
Use AutoFit

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.

3
Manually widen the column

Alternatively, click and hold the right boundary line, then drag it to the right until the full total appears.

AutoFit or Widen the Column
Quick Tip: You can select multiple columns at once and double-click any of their boundaries to AutoFit all of them simultaneously.
Seamlessly Manage Spreadsheets

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. 1. Open your file: Launch WPS Spreadsheet and open the document containing the cut-off totals.
  2. 2. Select the column: Click the column letter at the top to highlight the entire column.
  3. 3. AutoFit to display totals: Double-click the right boundary of the column header to automatically expand the width to fit your totals perfectly.
100% compatible with Microsoft Excel (.xlsx, .xls) formatsAutoFit columns instantly with a single double-clickFree, lightweight, and fast-loading for large datasetsAdvanced cell formatting options for precise data display
microsoft office alternative - wps office

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.