Wrap Text
Wrapping is not a break you place; it is a promise that the row will grow, and the column width alone decides where each line ends. That distinction settles most of what gets asked here. When the lines have to fall in particular places — an address, a two-line label — the break is a character you put in by hand, and no amount of wrapping will reproduce it. When wrapping is plainly switched on and nothing moves, someone has dragged that row border at some point — which pins its height for good — or the cells are merged; neither will ever grow on its own again, whatever the setting says.
The formula
Home > Wrap Text (Alt+H, W) turn wrapping on or off for the selection
Home > Format > AutoFit Row Height rescue a wrapped row that refuses to grow
Ctrl+1 > Alignment > Shrink to fit the alternative: a smaller font instead of more lines
Format > Wrapping (Google Sheets) three explicit states there — Overflow, Wrap, ClipA worked example
A2 holds a 90-character product description, and column A is 20 characters wide.
Select A2, then Home > Wrap Text
The description lays out over five lines inside A2 and the row height grows to match. Widen column A to 45 characters and it reflows to three lines on its own — the stored text never changed, only how many lines the current column width forces it into.
Which one do I need?
| If you want to… | Use |
|---|---|
| Making long text readable inside its own cell | Home > Wrap Text, then leave the row height alone so Excel is free to grow it |
| Choosing exactly where each line ends | Alt+Enter at the point you want the break — a character you place, not automatic reflow |
| Wrap is on but the row is still one line tall | The height was set by hand at some point; Home > Format > AutoFit Row Height returns it to automatic |
| Wrap is on but merged cells still cut the text off | Merged cells never grow their row height — unmerge them, or set the height yourself |
| Keeping everything on one line and shrinking the text instead | Ctrl+1 > Alignment > Shrink to fit, which cannot be combined with wrapping |
| Stopping text spilling across the next column without wrapping it | Excel clips it automatically as soon as the neighbouring cell holds anything, even a space; Google Sheets has an explicit Format > Wrapping > Clip |
Frequently asked questions
Why is Wrap Text not working?
Three causes cover almost every case. The row height was set manually — dragging a row border once stops Excel auto-sizing it, and Home > Format > AutoFit Row Height undoes that. The cells are merged, and merged cells never grow their row height. Or Shrink to fit is ticked under Ctrl+1 > Alignment, which takes precedence over wrapping.
What is the difference between Wrap Text and Alt+Enter?
Wrap Text is automatic: Excel reflows the text to whatever width the column currently is, and reflows it again every time you resize. Alt+Enter puts a real break character in the text at the point you picked, and it stays there no matter how wide the column becomes. Alt+Enter also switches Wrap Text on for you, which is exactly why the two get confused.
Does turning Wrap Text off delete anything?
No — wrapping is purely a display setting. The cell keeps its value untouched, including any Alt+Enter breaks stored inside it. With wrapping off, a long value simply spills across empty neighbouring cells, or is clipped at the cell edge where the neighbour has content. Switch wrapping back on and everything reappears.
How do I wrap text in Google Sheets?
Format > Wrapping, which offers three states rather than Excel's on/off: Overflow lets the text spill across empty cells, Wrap reflows it inside the cell, and Clip cuts it at the cell edge. The toolbar carries the same three icons. Rows auto-grow for wrapped text there in the same way, and merged cells cause the same trouble.
New guides and tools, once a month
DE + EN · double opt-in · no spam