To wrap text in Excel: select the cell or cells, then on the Home tab, in the Alignment group, select Wrap Text. The text wraps to the width of the column, and on a row whose height has not been fixed, the row grows taller so every line shows. On a Mac the same button sits on the Home tab, labeled Wrap Text.
Microsoft frames the whole feature in one line: “You can format the cell to wrap the text automatically or enter a manual line break.” This guide covers turning wrapping on, the manual line break that breaks a line exactly where you want, how wrapping differs from merging cells, why wrapped lines sometimes stay hidden, and how to turn wrapping back off.
How do I turn on text wrapping?
Select the cell or cells, then on the Home tab, in the Alignment group, select Wrap Text. The text reflows to fit the column width instead of running past the cell’s right edge, and if you widen or narrow the column later, the wrapping adjusts to the new width on its own. On a row whose height you have not set by hand, the row grows tall enough to fit every wrapped line.
| A | B | |
|---|---|---|
| 1 | Order | Status |
| 2 | 1042 | Shipped, waiting on signature |
| 3 | 1043 | Backordered |
On a Mac the button is on the Home tab as Wrap Text, with no separate Alignment group named in Microsoft’s Mac instructions. Either way, wrapping is a display setting: it changes how the cell shows its text, not the text itself. The cell still holds one continuous string.
How do I add a line break inside a cell?
Wrapping decides where each line breaks for you, at the column edge. A manual line break lets you choose the exact spot, which is what you want for something like a two-line address or a label that should always split at the same word.
Double-click the cell (or select it and press F2) to start editing, click at the point where the new line should begin, and press Alt+Enter on Windows. On a Mac, Microsoft’s keyboard-shortcut reference gives Control+Option+Return for starting a new line in the same cell, and Option+Return does the same job. Unlike turning on Wrap Text, a manual break puts a real line-break character into the cell’s text, so the split stays put no matter how wide the column gets.
Wrap text or merge cells?
These two get confused because both make a cell look roomier, but they do very different things. Wrapping keeps a single cell and stacks its text onto several lines inside it. Merging combines two or more cells into one larger cell, and only the upper-left cell’s contents survive the operation.
Merging also brings costs that wrapping does not, such as stopping a column from sorting once merged cells are in it. So if all you wanted was a long heading or note to show on several lines without spilling across neighbors, reach for wrapping rather than merging. When you do need cells combined, how to merge cells in Excel covers the merge commands, the deletion rule, and unmerging.
Why isn’t all my wrapped text showing?
You turn on wrapping and some lines still do not appear. Microsoft names the two causes: “If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.”
The fix depends on which one it is:
- A row set to a specific height. Give the row more room. Select the cell, then on the Home tab, in the Cells group, select Format, and under Cell Size choose AutoFit Row Height to size the row to its contents, or Row Height to type an exact value. You can also drag the bottom border of the row down until every line shows.
- A cell in a merged range. AutoFit does not work on rows that contain merged cells, so the automatic option cannot grow the row for you. Set the height yourself with Row Height, or drag the row’s bottom border down by hand.
On a Mac, Microsoft’s page names only the fixed-height cause and fixes it from the Format menu: point to Row, then click AutoFit to let the row size itself to the wrapped text.
How do I turn wrapping off?
Wrap Text is a toggle, not a one-way switch. Select the wrapped cell or cells and choose Home > Alignment > Wrap Text a second time, and the wrapping turns off, so the text drops back to one line and the row returns to its normal height. On a Mac, click Wrap Text on the Home tab again. Any manual line breaks you added with Alt+Enter stay in the text, though, because those are characters in the cell rather than a display setting, so a cell that still splits after you switch wrapping off is carrying a manual break.
The short version
- Wrap: select the cells, then Home > Alignment > Wrap Text (on a Mac, Home > Wrap Text). The text wraps to the column width, and a row without a fixed height grows taller to fit.
- Manual line break: Alt+Enter on Windows, or Control+Option+Return on a Mac, breaks the line exactly where the cursor sits, unlike Wrap Text, which breaks at the column edge.
- Wrap versus merge: wrapping keeps one cell and stacks the lines inside it; merging combines several cells into one, keeps only the upper-left contents, and can block sorting.
- Lines still hidden: the row is at a fixed height or in a merged range. Raise it with Home > Cells > Format > AutoFit Row Height, or set Row Height by hand (AutoFit does not work on merged cells).
- Turn off: select the cells and choose Wrap Text again; wrapping is a toggle, but a manual line break stays in the text.
- A display setting, not the value: wrapping changes how the text sits in the cell, never what the cell holds, the same as strikethrough and other font formats.
