9sBlog

How to Wrap Text in Excel

Learn how to wrap text in Excel with the Wrap Text button, add a manual line break with Alt+Enter, and fix cells where wrapped text still gets cut off.

To wrap text in Excel, select the cell or range, then click Wrap Text in the Alignment group on the Home tab. Excel breaks long text onto multiple lines so it fits the column width instead of spilling into the next cell. If you need a line break at a specific spot rather than wherever the column happens to end, use Alt+Enter instead — and if wrapped text still looks cut off afterward, the cause is almost always row height or a merged cell, not the wrap setting itself.

Turn On Wrap Text From the Ribbon

This is the standard way to wrap text automatically, and it works the same way whether you’re formatting one cell or an entire column.

  1. Select the cell, range, row, or column you want to format.
  2. Go to the Home tab.
  3. In the Alignment group, click Wrap Text (the icon shows text bending onto a second line).
  4. Excel expands the row height as needed so every wrapped line is visible.

Two things to know about this method:

  • Wrapped text reflows automatically. If you later widen or narrow the column, Excel recalculates where each line breaks.
  • You can also toggle it from the keyboard with Alt, H, W (press the keys in sequence, not together), or through Ctrl+1 to open Format Cells, then check Wrap text on the Alignment tab. Both do exactly what the ribbon button does.

Add a Manual Line Break With Alt+Enter

Wrap Text decides where to break lines based on column width, which is fine for a paragraph but not for something like an address or a multi-part label where you want the break in a fixed place. For that, insert the line break yourself:

  1. Double-click the cell (or select it and press F2) to enter edit mode.
  2. Click exactly where you want the line to break.
  3. Press Alt+Enter (on a Mac, Control+Option+Return).
  4. Repeat for any additional breaks, then press Enter to confirm.

Pressing Alt+Enter automatically turns Wrap Text on for that cell, since the extra line can’t display otherwise. That also means an Alt+Enter break behaves differently from automatic wrapping: it stays exactly where you placed it even if you resize the column, and if you later switch Wrap Text off for that cell, the manual break stops displaying as a separate line.

Fix Row Height and Merged Cell Problems

Wrap Text and Alt+Enter both depend on the row being tall enough to show every line, and merged cells complicate that further. Here’s how to read the symptom and fix it.

SymptomLikely causeFix
Wrap Text is on, but the last line is still cut offRow height was set manually and hasn’t grown with the contentSelect the row(s), then go to Home > Cells > Format > AutoFit Row Height
One row’s height won’t budge no matter what you tryThe row contains a merged cellExcel can’t autofit rows or columns that contain merged cells — unmerge the cell or set the row height manually with Home > Cells > Format > Row Height
Text wraps, but only part of it shows even after autofittingA merged cell is limiting the wrap widthUnmerge and use Center Across Selection (Format Cells > Alignment > Horizontal) instead, if you were only merging for visual centering
Line breaks from Alt+Enter don’t show as separate linesWrap Text got switched off for that cellRe-enable Wrap Text on the Home tab; the existing breaks will reappear

The merged-cell limitation is worth remembering on its own: Excel’s AutoFit feature simply does not work on rows or columns that contain a merge, which is why a row can look “stuck” even though every other row resizes correctly. If you rely on merged headers, plan to set that row’s height by hand.

A Few Practical Notes

Wrap Text and column width interact, so if a column is very narrow, wrapped text can end up as a tall stack of short lines that’s harder to read than a wider column with fewer wraps. Widening the column first, then applying Wrap Text, usually produces a cleaner result than wrapping a narrow column and fighting the row height afterward.

If you’re formatting data you’ll also filter or sort, keep in mind that wrapped or multi-line cells still sort by their full text content, so wrapping is purely visual and won’t change how formulas like those in a pivot table or a VLOOKUP read the cell. And if you’re locking down a template that uses wrapped headers so people don’t accidentally resize them, see our guide on how to lock cells in Excel.

Wrap Text and Alt+Enter solve two different problems: one reflows automatically with the column, the other puts a break exactly where you want it. Once you know which one you’re fighting, row height and merged-cell issues are quick to diagnose with the table above.

Discussion

    Leave a comment