If Excel text wrap is not working, turn on Home > Alignment > Wrap Text, then make sure the row is tall enough to show the wrapped lines. A fixed row height, merged cells, or an unexpected alignment setting is often the reason text still looks cut off after wrapping is enabled.
What Wrap Text does—and what it does not do
Wrap Text keeps a cell’s content within its current column width by displaying it on multiple lines. Excel usually increases the row height to reveal those lines, so the column does not have to become wider. For example, a long note in a narrow column can occupy three lines in one cell rather than spilling across neighboring blank cells.
Wrapping changes how content is displayed, not the content itself. It does not insert spaces, edit the text, or split it into several cells. The cell still contains one value, which matters if you later sort, search, or use that value in a formula.
There is also a common visual mix-up: unwrapped text can appear to run into the next cell when that neighboring cell is empty. If the next cell contains anything, Excel generally clips the visible text at the cell boundary. Wrap Text instead makes the content continue on lower lines inside the original cell.
Turn wrapping on and check the selected cells
In Excel for Microsoft 365 on Windows, select the affected cell or range and choose Home > Alignment > Wrap Text. The button is a toggle, so selecting it again turns wrapping off. If the button appears active but a particular cell is still clipped, check the row height and the other causes below rather than repeatedly toggling the setting.
- Select the cell, range, or entire worksheet area that needs wrapping.
- Choose Home > Alignment > Wrap Text.
- Look at the row boundary on the left. If the row has not expanded, use AutoFit Row Height or adjust its height manually.
- Check whether the cell is merged, the row is hidden, or the text is being affected by another alignment setting.
To select an entire worksheet, click the triangle at the intersection of the row and column headings, then apply Wrap Text. Be cautious with this approach in a large workbook: changing alignment across every cell can make existing layouts look different. It is usually better to select only the relevant columns or range.
AutoFit the row height
Wrap Text can be enabled while the row remains too short to display all the lines. This commonly happens when someone previously set a specific row height, copied formatting from another range, or resized rows for a printed layout. The text may be present, but the bottom lines are hidden by the cell boundary.
To let Excel size the row to its contents, select the affected rows and choose Home > Cells > Format > AutoFit Row Height. You can also move the pointer to the boundary below a row number and double-click it. For several rows, select them first; the same AutoFit command applies to the selection.
AutoFit recalculates the height based on the current contents and column width. If you later make the column narrower, text may wrap onto more lines and the row may need to grow again. Re-run AutoFit after substantial width or font changes if some lines are no longer visible.
If AutoFit does not resolve the problem, set a larger height manually. Choose Home > Cells > Format > Row Height and enter a value. This is useful when you want rows to have a consistent size, but a fixed height can clip text again if the cell content changes.
Merged cells and other layout limitations
Merged cells are a frequent source of confusion. Excel can wrap text in a merged area, but AutoFit Row Height does not reliably calculate the required height for merged cells. The row may stay too short even though Wrap Text is on, making it appear that wrapping has failed.
For a merged cell, try increasing the row height manually until all lines show. If the sheet is still being designed, consider avoiding the merge. Merging can interfere with sorting, filtering, selecting ranges, and some layout operations. For a heading that should look centered across several columns, Center Across Selection can sometimes provide the appearance without merging: open the Format Cells dialog, select the Alignment tab, and choose it from the Horizontal list.
Also check whether the row is hidden. A row height of zero or a hidden row cannot display its text, wrapped or otherwise. Select the rows above and below it, right-click a row heading, and choose Unhide. If the worksheet is filtered, a row may be excluded from view; clear or adjust the filter before assuming that its content disappeared.
Review alignment, column width, and font size
Wrapping is easiest to diagnose when the column width is stable. A very narrow column can produce many short lines and make the row unexpectedly tall. A wide column may put the entire value on one line, so wrapping is technically enabled but there is no visible break. Adjust the column width to the layout you actually want, then AutoFit the row height.
Check vertical alignment as well. In Home > Alignment, choose an appropriate vertical position, such as Top Align or Middle Align. Vertical alignment does not create or remove wrapping, but it changes where the visible lines sit within a tall row. If text looks missing, inspect the full row height and the cell boundary rather than relying only on where the first line appears.
Font size and formatting can also change the number of lines. A larger font, bold characters, or a different typeface may require more width or height. If the problem began after pasting content, select the affected cells and inspect the font and alignment settings. To remove unintended formatting, use Home > Editing > Clear > Clear Formats, but note that this also clears other formatting such as number formats, borders, and fills.
Manual line breaks, formulas, and pasted text
Wrap Text and a manual line break are different. Wrapping lets Excel choose where lines break based on the cell width. A manual break forces a new line at a specific place, even if the column later becomes wider. In Excel for Windows, edit the cell, place the insertion point where the break should go, and press Alt+Enter. In Excel for Mac, the line-break shortcut is generally Control+Option+Return; keyboard behavior can vary with the Mac layout and Excel version.
When text has manual breaks, turning Wrap Text off does not remove those breaks. Conversely, enabling Wrap Text does not insert manual breaks into the underlying value. If pasted text has unexpected line breaks, edit the cell to inspect where the lines begin, or paste the text into a plain-text editor to see whether the breaks are part of the source.
Formula results can wrap too. If a formula returns a long text string, apply Wrap Text to the cell containing the formula and check the row height just as you would for typed text. If the formula returns a number or date, make sure the issue is not actually a display format or a column that is too narrow; wrapping is intended to arrange text over multiple lines, not to fix every kind of clipped value.
Excel for the web and Mac differences
In Excel for the web, select the cells and use Home > Wrap Text on the ribbon. The core behavior is similar: the text stays in the cell, and row height affects how much of it is visible. If a web workbook appears different from the desktop version, check the row height and whether the file has merged cells before changing the content.
Excel for Mac also has a Wrap Text control on the Home tab, though the ribbon arrangement can vary with window size and ribbon customization. The Windows path for AutoFit is Home > Cells > Format > AutoFit Row Height; on Mac, use the Home tab’s Format controls or double-click the lower boundary of a selected row heading. The exact menu presentation can differ, but the underlying checks—wrapping, row height, merged cells, and column width—are the same.
A practical troubleshooting order
Work through the following sequence before changing the text itself. It isolates the display problem while minimizing unnecessary formatting changes:
- Confirm the target: select the cell that is clipped and verify Wrap Text is on for that cell, not just for a neighboring range.
- AutoFit the row: use the Format menu command or double-click the row boundary.
- Inspect the row: unhide it if needed, and check whether a filter is hiding it from view.
- Check for merging: if the cell is merged, increase row height manually or consider a non-merged layout.
- Review width and formatting: adjust the column width and check font size, vertical alignment, and manual line breaks.
- Test a single cell: apply the setting to one ordinary, unmerged cell with a known long text value. If that works, the issue is likely specific to the original range’s formatting or structure.
A useful example is a Notes column that is 20 characters wide, with a row height set to 18 points. A sentence may need three lines, but the fixed row shows only the first. Turn on Wrap Text and AutoFit the row; if the cell is merged with adjacent columns, AutoFit may not expand it, so assign a taller height manually. This distinguishes a row-size problem from a failure to store the full sentence.
Frequently Asked Questions
Why does Excel show only one line even though Wrap Text is on?
Most often, the row height is fixed or too small. Select the row and choose Home > Cells > Format > AutoFit Row Height. If the cell is merged, set the height manually because AutoFit may not size merged content correctly.
Does Wrap Text change the cell value?
No. It changes how the existing value is displayed. The text remains in one cell unless you edit it or use another operation to split it. Manual line breaks are separate characters within that cell’s content.
Why does AutoFit Row Height not work on a merged cell?
Excel does not reliably AutoFit row height for merged cells. Increase the row height yourself, or redesign the layout without a merge if you need reliable automatic sizing.
How can I make text wrap at a specific point?
Insert a manual line break while editing the cell: press Alt+Enter in Excel for Windows. On Mac, use Control+Option+Return in current Excel builds. The break remains at that point even if the column width changes.
Why does wrapped text look like it disappears after I resize a column?
A narrower column can create more lines and require a taller row. AutoFit the row again, or increase its height manually. A fixed row height may clip the extra lines even though the full value is still in the cell.
In most cases, the fix is straightforward: enable Wrap Text on the correct range and give the row enough height. If those steps do not work, inspect merged cells, hidden rows, manual breaks, and formatting before replacing or retyping the text.
Related
- Merge Cells and Keep Both Values in Excel Without Data Loss
- How to Remove a Dropdown List from an Excel Cell
- Remove a Dropdown List in Excel Without Losing Data
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- XLOOKUP If Not Found Not Working? How to Fix ItIf XLOOKUP is not showing your “not found” message, first check that the message is supplied as the…
- VLOOKUP Not Working but Value Is There?If VLOOKUP says a value is missing even though you can see it, the usual causes are an…
- INDEX MATCH #REF! Error: How to Find and Fix the CauseA #REF! error in an Excel INDEX MATCH formula means that part of the formula points to a…
- DDE Error in Excel: What It Means and How to Fix ItA DDE error in Excel usually means Windows or another program cannot pass a request to Excel through…
- Excel Error Symbols: What They Mean and How to Fix ThemExcel’s error symbols are values such as #VALUE! and #DIV/0! that explain why a formula cannot return a…
- Excel #REF! Error: How to Fix and Prevent Reference ErrorsTo correct a #REF! error in Excel, inspect the formula that shows the error, identify the missing cell,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.