Excel Cell Text Overflow: Causes and Fixes

How-to basics · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, text in a cell can display across neighboring cells when they are empty; if the next cell contains anything, the text appears clipped, but the underlying value is still there. To show more of it, widen the column, turn on Home > Wrap Text, or use Home > Format > AutoFit Column Width, choosing the method that best fits your sheet.

What Excel cell text overflow means

Excel keeps a cell’s contents separate from how much of those contents are visible on the worksheet. A long text entry may extend visually into one or more empty cells to its right. This display behavior is often called text overflow or text spilling. It does not put part of the text into those neighboring cells, and it does not change the value stored in the original cell.

For example, if A2 contains “Waiting for supplier confirmation” and B2 is empty, the words may appear to run across B2 and beyond. Select A2 and look at the formula bar to inspect the complete entry. If B2 contains a value, a formula, or even a formula that returns an empty string, it blocks the visual spill. Excel then shows only the portion that fits in A2’s column. The remaining text is still in A2.

Overflow is therefore a display issue, not usually a data-loss problem. It can nevertheless make a worksheet difficult to read: a label may look incomplete, appear to run into a neighboring heading, or seem to have overwritten another cell. Understanding what is in the cells beside the text helps distinguish normal clipping from a genuine editing mistake.

Why text spills or gets cut off

Excel’s default alignment helps explain what happens. Text is generally aligned to the left, so it has room to extend to the right when adjacent cells are empty. Numbers are generally aligned to the right and do not display in the same way. Alignment settings, cell formatting, worksheet direction, and whether a cell is part of a table can also affect what you see.

  • The neighboring cells are empty: Excel can show the text beyond the original cell’s right edge.
  • A neighboring cell is occupied: The visible text is clipped at the boundary. A formula returning an empty string still occupies its cell for this purpose.
  • Text wrapping is on: The text is displayed on multiple lines inside the cell instead of spilling horizontally.
  • The cell is merged or specially aligned: The usual overflow behavior may not apply, and resizing can be less predictable.
  • The cell is in an Excel table: Table layout and neighboring table columns can make long entries appear clipped rather than allowing them to spill into the next column.

A blank-looking cell is not necessarily empty. It might contain spaces, a formula, or content formatted so that it is hard to see. Click it and check the formula bar, or select it and press Delete only if you are sure its contents are not needed. Clearing a neighboring cell simply to make text spill can remove data or formulas, so resizing or wrapping is usually safer.

How to make the full text visible

Use one of these approaches in Excel for Microsoft 365 on Windows. The best choice depends on whether you want a compact sheet, a single-line view, or a readable multi-line entry.

  1. Widen the column manually. Drag the right edge of the column letter’s header. This is useful when a small increase will make most entries readable without changing the row layout.
  2. AutoFit the column. Select the column or columns, then choose Home > Format > AutoFit Column Width. You can also double-click the right boundary of a column heading. Excel adjusts the width to accommodate the widest displayed entry in the selection; a very long entry can make the column much wider than you want.
  3. Wrap the text. Select the cells and choose Home > Wrap Text. Excel places the entry on additional lines within the existing column width and may increase the row height. Adjust the column width and row height afterward if the result is not easy to read.
  4. Shrink the text to fit. Press Ctrl+1 to open Format Cells, select the Alignment tab, and select Shrink to fit. This reduces the displayed font size as needed to fit the entry on one line. It does not change the cell’s stored text or the worksheet’s actual font setting, but very long entries can become hard to read.
  5. Increase the row height. If wrapped text is only partly visible, drag the bottom edge of the row heading or use Home > Format > AutoFit Row Height. A fixed row height can hide wrapped lines.

On Excel for Mac, the Wrap Text and Format commands are available on the ribbon, though ribbon organization and keyboard shortcuts can differ by release. Command+1 opens Format Cells on Mac; Ctrl+1 is the Windows shortcut. Excel for the web also provides wrapping and column resizing, but some desktop formatting controls and interactions may be arranged differently.

Choosing the right display method

Widening a column is a good fix for a short label, but it can waste space when a worksheet has many fields. Wrapping is often better for notes, descriptions, addresses, and headings because it preserves the column width and keeps each entry within its own cell. It can make rows taller, however, so a sheet with hundreds of long notes may become cumbersome to scan.

Shrink to fit is useful for short identifiers or headings that must remain on one line in a fixed-width layout. Avoid relying on it for paragraphs: a long entry may be reduced to text that is too small to read. For a presentation or report, consider widening selected columns and wrapping only the descriptive fields rather than applying one setting everywhere.

AutoFit is convenient when you want Excel to choose a width, but review the result. One unusually long value can expand an entire column and push other columns off screen. You can AutoFit a selection, manually narrow the column afterward, or wrap the long entries instead. Column width is a layout measurement influenced by the font, so it is not a precise promise that a fixed number of characters will fit.

If a heading should be centered over several columns, merging cells is not always the best solution. Merged cells can make sorting, selecting, and resizing more awkward. In Format Cells > Alignment, the Horizontal list includes Center Across Selection, which centers text across selected cells without combining them. Use it when that layout is appropriate, and check the result in your version of Excel.

Numbers, dates, and the ##### display

A row of hash marks (#####) is different from ordinary text clipping. Excel commonly displays hash marks when a numeric value or date/time cannot fit in the column at its current number format. The value has not necessarily been replaced with hash characters. Widen the column, use AutoFit, or choose a shorter number format to inspect it.

For dates and times, changing the format can be more practical than making a column very wide. For example, a full date with a long weekday name takes more space than a short date. Select the cells and use Home > Number Format to choose a suitable format, or open Format Cells with Ctrl+1 on Windows and select a format under Number. Check that the shorter display still communicates the precision readers need.

Not every display of hash marks means a narrow column. A cell containing text made up of hash symbols may show those symbols as actual content. Also, negative date or time results can display as hash marks in some Excel date systems. Check the formula bar and the cell’s number format before assuming the column width is the only cause.

Common problems and troubleshooting

If text still seems missing after you widen a column, check the cell itself rather than relying only on its visible edge. Select it and read the formula bar. If the formula bar also shows only part of the entry, the content may actually have been shortened or replaced during editing or import. Excel’s usual visual clipping does not delete the hidden part, but another operation may have changed the stored value.

  • Wrap Text is enabled but lines are hidden: Increase the row height or use Home > Format > AutoFit Row Height. Check whether the row has a manually fixed height.
  • AutoFit makes the column huge: A long note or URL may be setting the width. Undo if appropriate, then set a practical width and wrap the long entries.
  • Text stops at a cell that looks blank: Select the neighboring cell and inspect the formula bar. A formula, spaces, or other hidden content may be blocking the spill.
  • Only some cells behave differently: Compare their alignment, wrapping, number format, and whether they are merged or inside a table. A pasted format can make cells behave differently even when their contents look similar.
  • The last wrapped line is not visible: Check row height and merged cells. AutoFit may not size rows containing merged cells as expected, so adjust the row height manually or reconsider the merged layout.

To reveal hidden columns or rows, select the headings on both sides of the hidden area, right-click, and choose Unhide. Hiding a column is different from text overflow: the column and its contents are still present, but not displayed. If a workbook is protected, some layout changes may be restricted until the sheet is unprotected by someone authorized to do so.

Copying, printing, and sharing the worksheet

Overflow is a screen display behavior, so a worksheet that looks readable on one monitor may not print the same way. Page scaling, paper size, margins, and print area can reduce the available width. Use File > Print to inspect the preview before distributing a worksheet. If text is cut off in the preview, adjust the column widths, wrapping, page orientation, or scaling and review the result again.

When sharing a workbook, consider how the recipient will view it. A column that is readable on a desktop may require horizontal scrolling on a phone or a narrow browser window. Wrapping important descriptions, using clear headings, and avoiding extremely wide columns can help. If you export to PDF, inspect the exported pages too; a screen layout does not guarantee a readable print layout.

Copying a cell’s text into another application is also different from copying the visible worksheet area. The full stored value can be copied even when only part of it appears on the grid. If you need to verify the exact content, select the cell and copy from the formula bar, or paste it into a suitable text editor. Avoid deleting adjacent values merely to expose text unless you have checked what those cells contain.

Frequently Asked Questions

Does Excel cell text overflow mean the text is cut off?
No. When Excel clips text because a neighboring cell is occupied, the full value usually remains in the original cell. Select it or check the formula bar to see the complete entry.

Why does text overflow into a blank-looking cell?
The neighboring cell may contain a formula, spaces, or other content even if it looks blank. Select it and inspect the formula bar. A formula that returns an empty string can still prevent text from spilling across it.

How do I stop text from overflowing into other cells?
Turn on Home > Wrap Text, widen the column, or use Shrink to fit from Format Cells > Alignment. Wrapping is often the clearest option for long descriptions; shrink-to-fit can make them too small.

Why does Excel show ##### instead of my text?
Hash marks usually indicate that a number or date/time does not fit its column or that a date/time result cannot be displayed in the current format. Widen the column and check the number format and underlying value.

Will AutoFit always show every entry?
AutoFit adjusts a column to fit its widest displayed entry, which can create an impractically wide column. It may also not handle some merged-cell layouts as expected. Wrap text or set a useful width manually when AutoFit is not suitable.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.