If text looks as though it is spilling out of an Excel cell, it usually has not moved: Excel is displaying the cell’s contents across neighboring empty cells. To keep it visually inside its own cell, select it and choose Home > Alignment > Wrap Text; you can also widen the column or use Shrink to fit.
What Excel means by text overflowing
A worksheet cell can contain more text than its current column width can show. By default, left-aligned text may continue across the blank cells to its right, making it look as though the words belong to those cells. The value still belongs only to the cell where you entered it. Click that cell and check the formula bar above the worksheet to confirm where the complete text is stored.
Overflow is a display behavior, not a change to the underlying data. For example, if A2 contains Customer follow-up required and B2 is empty, the words may appear over both columns. If B2 contains anything, Excel generally stops displaying A2’s text at the cell boundary. The contents in B2 do not have to be visible: a formula that returns an empty string can still make that cell occupied and block the overflow.
Excel’s gridlines can make this confusing because they show cell boundaries without necessarily showing the edge of the text. A long sentence crossing a gridline is not proof that Excel has split it. Select the apparent starting cell, then look at the formula bar or press F2 to inspect its contents. Press Esc to leave edit mode without making a change.
Keep the full text visible with Wrap Text
Wrapping is usually the clearest fix when you want to keep the column narrow and read the complete entry. It puts the text on additional lines within the same cell and increases the row height as needed. On Excel for Microsoft 365 on Windows:
- Select the cell or range containing the text.
- Choose Home > Alignment > Wrap Text.
- If the full text still is not visible, adjust the row height or column width. You can use Home > Cells > Format > AutoFit Row Height to fit the row to its contents.
Wrapping changes how the text is displayed, not the text itself. It is useful for notes, addresses, descriptions, and column headings. You can wrap a whole column or selected range, but a very long entry may create a tall row that makes the rest of the sheet harder to scan. Consider widening the column slightly as well, or using a separate details column if the long text is not essential in the main view.
On Excel for Mac, the Wrap Text command is also on the Home tab in the Alignment group. Ribbon labels can vary slightly with window size, but the command has the same purpose. Excel for the web also offers Wrap Text from its Home ribbon.
Choose between widening, wrapping, and shrinking
There is no single best display setting for every worksheet. Choose based on whether readability, compactness, or a consistent layout matters most:
- Widen the column when the text is short enough to fit and you want a single-line row. Drag the boundary between column letters, or double-click that boundary to AutoFit the column to its contents. The ribbon command is Home > Cells > Format > AutoFit Column Width.
- Wrap the text when a narrow column is important but readers need to see the complete entry in the worksheet. This is often the best option for notes and descriptions.
- Shrink to fit when the text must remain on one line in a fixed-width cell. Press Ctrl+1 on Windows, open the Alignment tab in Format Cells, and select Shrink to fit. On Mac, Command+1 opens Format Cells in many Excel versions.
- Allow overflow when the next cells are empty and the text is easy to read. This keeps rows compact, although the visible text may disappear once something is entered in a neighboring cell.
Shrink to fit reduces the displayed font size; it does not make the column wider or shorten the stored text. It can make a long entry difficult to read, especially if the cell contains much more text than its neighbors. For a worksheet meant for printing or for people to read on screen, wrapping or increasing the column width is often more accessible.
Why text may be cut off instead of overflowing
When the next cell in the direction of the text is occupied, Excel cannot display the overflow across it, so the text appears clipped at the cell edge. The underlying value is still present. If the text is left-aligned, inspect the cell to its right; if it is right-aligned, inspect the cell to its left. Center alignment, indentation, and text orientation can also change how the content appears relative to the cell boundaries.
Check for content that is easy to overlook. A neighboring cell might contain a space, a formula, or a value formatted to look blank. Select that cell and look in the formula bar before deleting anything. If it contains important data, do not clear it just to make the other text appear longer; use Wrap Text, widen the column, or adjust the layout instead.
A number or date that does not fit behaves differently from ordinary text. Excel may display hash marks, such as ####, when a numeric value or date cannot fit in the column. Widen the column first. If the value is a date or time, also check whether the cell’s number format is appropriate. Hash marks do not normally mean that the number has been replaced or erased.
Check row height, merged cells, and formatting
Wrapped text can seem to vanish when the row is too short to show all its lines. Select the row and choose Home > Cells > Format > AutoFit Row Height, or drag the row boundary to increase its height. If the row has a fixed height, Excel may clip wrapped lines rather than expand the row automatically. This can happen in carefully formatted reports or templates where row heights were set manually.
Merged cells need extra care. A merged range combines several cells into one display area, and Excel may not automatically adjust its row height to show all wrapped text in that range. If text is missing, try increasing the row height manually or unmerging the cells and using a layout that does not depend on a merge. Merging can also make sorting, filtering, and copying ranges more awkward, so it is rarely the best general-purpose solution for long descriptions.
Formatting can create an appearance problem even when the cell size is adequate. Check text orientation, indentation, horizontal alignment, and font size in Format Cells > Alignment or on the Home tab. If the text is rotated or indented, it may not sit where you expect. Resetting alignment to a standard left or general setting can help diagnose the issue, but note the original formatting first if the sheet is a template.
Tell a display issue from a data-entry problem
If the text is not merely cut off but seems to be missing after you press Enter, inspect the cell itself and the formula bar. Also check whether you edited the intended cell, whether a filter or hidden row is affecting what you see, and whether a formula is producing the displayed result. A formula result may look like typed text while the formula bar shows the formula that generates it.
Excel cells support long entries, but the worksheet view is not designed to show unlimited text in a compact grid. A cell can contain up to 32,767 characters, while only a limited portion may be displayed directly in the cell. For very long content, the formula bar, the in-cell editing view, or a separate document or notes field may be more practical than making one worksheet row exceptionally tall.
If text seems to change rather than simply disappear, check the cell’s number format and any data validation rules or formulas feeding the cell. For example, a formula may return a shortened label, or a custom number format may display a value differently from how it is stored. These cases are different from visual overflow and require fixing the source, formula, or formatting rather than widening a column.
Prevent overflow problems in shared worksheets
For a sheet that other people will use, decide how each column should behave and apply that formatting consistently. Short labels can remain on one line, while columns for comments can wrap. Use a reasonable starting width and avoid setting every column to AutoFit if a single unusually long entry would make the entire sheet too wide.
- Use clear headers so readers know which cell owns a long value.
- Wrap descriptive fields and set a useful row height for the normal case.
- Keep neighboring cells visibly separate when users need to enter data beside long text.
- Preview the worksheet at its intended zoom level and in Print Preview if it will be printed.
- Test a representative long entry before distributing a template.
Remember that a display choice is not a data-cleaning operation. Wrapping, shrinking, and changing column width do not remove characters. Conversely, clearing a neighboring cell to reveal overflow can delete real data. When the sheet contains important entries, verify the cell contents before changing or clearing anything.
Frequently Asked Questions
Why does my Excel text go into the next cell?
Excel is showing text overflow because the cell to the right is empty. The text remains in the original cell. Turn on Wrap Text, widen the column, or leave the overflow if that presentation is suitable.
How do I stop text from spilling over in Excel?
Select the cells and choose Home > Alignment > Wrap Text. If you need one line, widen the column or use Shrink to fit in the Alignment tab of Format Cells.
Why is only part of my text visible even though the next cell looks blank?
The neighboring cell may contain a space or a formula that displays an empty result, which can block overflow. Select it and inspect the formula bar. The row may also be too short if the text is wrapped.
Does text overflow mean Excel moved or deleted my data?
No. Overflow changes only what you can see on the grid. Select the cell and check the formula bar to confirm the stored contents. If the value is genuinely absent there, investigate data entry, formulas, or the cell you selected.
Why does Excel show #### instead of my text or number?
Hash marks usually indicate that a numeric value or date does not fit in the column, rather than ordinary text overflow. Widen the column and check the cell’s number format.
Related
- Data Validation and Reconciliation in Excel Explained
- PowerPoint Table Diagonal Split Cell: Practical Methods
- Data Validation and Quality Assurance in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Error Messages: What They Mean and How to Fix ThemExcel error messages are codes such as #DIV/0!, #VALUE!, and #REF! that show a formula could not return…
- Excel Find Not Working? Causes and Fixes ExplainedExcel’s Find command usually fails because it is searching the wrong sheet or selection, looking in formulas instead…
- Excel File Not Opening? Fix Corruption and Recover DataIf an Excel file will not open and Excel reports corruption, make a copy first, then try File…
- Excel Circular References: How to Find and Fix ThemIn Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References to see…
- VLOOKUP Not Working? Fix Common Excel Lookup ErrorsIf VLOOKUP is not working in Excel, first set its final argument to FALSE for an exact match,…
- Excel Value Filter Not Working? Fix the Common CausesIf an Excel value filter is not working, first clear the current filter and check that the column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.