Excel Cell Not Showing All Text? Fix It

Errors & fixes · Updated November 18, 2026

If an Excel cell is not showing all its text, first select it and choose Home > Wrap Text; then widen the column or increase the row height if needed. Text can also be hidden because the next cell contains data, the cell is merged, the formatting is unsuitable, or Excel is displaying a value as ####.

Why Excel hides or clips cell text

Excel does not automatically make every column and row large enough to display all its contents. In a worksheet, text normally appears to spill into the empty cells to its right. If the neighboring cell contains anything—even a space, a formula that returns an empty string, or content you cannot easily see—the text cannot spill into it and is cut off at the cell boundary. The complete value is usually still stored in the original cell.

Numbers, dates, and times behave differently from ordinary text. They generally do not spill across empty cells, so a narrow column may show only part of a number or display a row of number signs. That display does not necessarily mean the underlying value has been removed. Selecting the cell lets you inspect its value in the formula bar, above the worksheet.

It helps to distinguish three situations: the value is present but visually clipped; the cell is displaying a substitute such as ####; or the value itself is shorter than expected because it was entered, imported, or calculated that way. Each situation has a different fix, so check the formula bar before changing the worksheet.

Quick fixes: wrap text and resize cells

For a long sentence or description, wrapping is often the clearest solution. Select the cell or range, then choose Home > Wrap Text. Excel breaks the displayed text onto multiple lines within the existing column width. It may increase the row height automatically, although a manually fixed row height can prevent all the wrapped lines from appearing.

If you want the content on one line, make more room instead. Drag the boundary on the right side of the column heading to widen the column. To fit the widest content in the selected column, double-click that boundary, or select the column and choose Home > Format > AutoFit Column Width. AutoFit can make a column much wider than is practical if one cell contains a long paragraph.

For rows, drag the boundary below the row number to increase the height. To let Excel calculate a suitable height, select the row and choose Home > Format > AutoFit Row Height. You can also select a whole worksheet using the triangle at the top-left corner between the row and column headings, then apply an AutoFit command. Check the result afterward: fitting every column to its longest entry can make a worksheet difficult to read.

  • Use Wrap Text for notes, addresses, and descriptions that should stay within a chosen column width.
  • Widen the column when the content is short enough to fit on one line.
  • Increase or autofit the row height when wrapped lines are cut off vertically.

When text will not overflow into the next cell

Text spilling into adjacent cells is a display behavior, not a way to store content across several cells. Excel can show the overflow only when the cells to the right are available. If text stops at a particular boundary, inspect the neighboring cells for values, formulas, spaces, or formatting that may indicate where data was entered. A cell containing a formula that returns an empty string can look blank but still affect overflow.

There is no need to delete neighboring data just to reveal a sentence. Use Wrap Text, widen the original column, or move the text to a larger area. If the adjacent content matters, widening the column may simply push it farther across the worksheet, so wrapping is usually better for a readable table.

Merged cells are another common source of confusion. Text in a merged range may not display correctly after AutoFit, and Excel’s automatic row-height adjustment is limited for merged cells. If a merged heading is clipped, try manually increasing the row height or adjusting the column widths in the merged area. For data tables, avoiding merged cells is often more reliable: center the heading across a selection with alignment options instead, or put the heading in a single cell.

Check row height, alignment, and formatting

Wrapping can be enabled and still leave text hidden if the row is too short. This often happens when someone previously set a specific row height, or when a worksheet was copied from another file. Select the affected row and use Home > Format > AutoFit Row Height. If the row does not expand—especially when it contains merged cells—drag its lower boundary manually.

Vertical alignment can affect where text appears within a tall cell. Select the cell and use the alignment controls in Home > Alignment to choose Top Align, Middle Align, or Bottom Align. If the text appears to be missing, but the row is unusually tall, changing the vertical alignment may make it visible without altering the content.

Font color can also make text seem absent. A font that matches the fill color, or conditional formatting that changes the font color, may hide characters against the background. Check the font color and cell fill on the Home tab, and inspect Home > Conditional Formatting > Manage Rules if the appearance changes with the cell’s value. Clearing formatting can help diagnose a problem, but it may remove useful number formats and styles, so try it on a copy or use it only after checking what the cell needs.

What #### means—and what it does not mean

A row of #### is usually not a sign that a value has been erased. The most common cause is that a numeric value, date, or time does not fit in the column. Widen the column or use AutoFit Column Width. If the cell contains a date or time, confirm that the number format is appropriate; a long date format needs more space than a short date format.

There are exceptions. Excel can display #### for a date or time calculation that produces a negative result under the workbook’s date system. In that case, widening the column will not solve the underlying issue. Check the formula and the values it uses. For a large number, you can also choose a less space-consuming number format or adjust decimal places, provided that doing so does not misrepresent the precision readers need.

To identify what is stored, select the cell and look at the formula bar. If the formula bar shows the expected number or date, the issue is presentation or calculation display—not missing content. If it shows something else, check the formula, source data, or import process.

Long text, line breaks, and Excel’s display limit

Excel cells can store up to 32,767 characters, but the worksheet grid displays only up to 1,024 characters in a cell. The formula bar can show more of the cell’s contents, so a very long entry may be present even when the grid does not display every character. For lengthy notes or imported text, consider storing the full material in a document or a system designed for long-form content, then keeping a concise summary or reference in the worksheet.

You can put a line break inside a cell to control where a label or address wraps. In Excel for Microsoft 365 on Windows, edit the cell, place the insertion point where the break should go, and press Alt+Enter. On a Mac, the line-break shortcut is Control+Option+Return. Wrap Text may be needed to display the resulting lines, and the row must be tall enough to show them.

When text comes from a website or another system, it may contain unexpected spaces or line breaks. These characters can make a cell look blank, force text onto additional lines, or interfere with overflow. You can inspect the cell in the formula bar and, if appropriate, clean the source data before adjusting widths. Avoid replacing the content blindly: spaces and line breaks may be meaningful in addresses, descriptions, or identifiers.

A practical troubleshooting order

Use this sequence to find the cause without changing more of the worksheet than necessary:

  1. Select the cell and inspect the formula bar. Confirm whether the full expected text or value is stored there.
  2. If the cell contains ordinary text, turn on Wrap Text. If it should remain on one line, widen the column instead.
  3. If wrapped lines remain hidden, autofit or manually increase the row height.
  4. If text stops at the next column, check whether neighboring cells contain data or formulas, including formulas that return blank-looking results.
  5. If the cell shows ####, widen the column first, then check the number format and any date or time calculation.
  6. If the layout still looks wrong, inspect merged cells, vertical alignment, font color, and conditional formatting.

This order separates a display problem from a content problem. It also helps avoid deleting adjacent values or clearing formatting that other parts of the worksheet depend on.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Windows, the main controls are on the Home tab: Wrap Text is in the Alignment group, and the AutoFit commands are under Home > Format. On Excel for Mac, the ribbon provides similar wrapping and sizing controls; the exact placement can vary with the ribbon layout and window size. The Mac keyboard shortcut for a line break within a cell differs from Windows, as noted above.

Excel for the web also supports wrapping text and adjusting column widths and row heights. Some advanced formatting behavior and controls can differ from the desktop app, so if AutoFit or a merged-cell layout does not behave as expected, open the workbook in the desktop version. The underlying cell value should remain available even when the browser view clips it.

Frequently Asked Questions

Why is only part of my Excel text visible?
Usually the column is too narrow, the next cell contains data and blocks overflow, or the row is too short for wrapped text. Select the cell and check the formula bar to confirm whether the full text is stored.

How do I make Excel show all text in a cell?
Select the cell and choose Home > Wrap Text, then autofit or increase the row height. If you want one line, widen the column instead.

Why does Excel show #### instead of my value?
A number, date, or time often needs more column width. Widen the column first. If the value is a date or time and #### remains, check whether the calculation produced a negative result.

Why does AutoFit not show all wrapped text?
A fixed row height or merged cells can prevent the row from expanding as expected. Increase the row height manually, and consider avoiding merged cells in areas where content needs to adjust automatically.

Is my text lost if the cell looks blank or cut off?
Not necessarily. Select the cell and inspect the formula bar. If the expected content appears there, the problem is how the cell is displayed; if it does not, investigate the source value or formula.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.