Docs · guide
By Alberto Gulotta · Updated · 12 min read
How to wrap text in Excel: there are two ways to put text on more than one line in a cell, and Microsoft names both in one sentence — “format the cell to wrap the text automatically or enter a manual line break.” The first reflows with the column; the second stays where you put it.
| What you want | Excel on Windows | Excel for Mac | Source |
|---|---|---|---|
| Wrap the text automatically | Home › Alignment › Wrap Text | Home › Wrap Text | Microsoft |
| Show the lines that are cut off | Home › Cells › Format › AutoFit Row Height | Format menu › Row › AutoFit | Microsoft |
| Set the height yourself instead | Home › Cells › Format › Row Height | Drag the bottom border of the row | Microsoft |
| Break a line where you choose | Double-click or F2, then Alt + Enter | Not documented on Microsoft’s Mac page | Microsoft |
automatic, and it reflows
Wrap Text
Select the cells, then Home › Alignment › Wrap Text.
Microsoft: “Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.” The lines are not yours — they are recalculated every time the column moves.
Right for a long note or a description, where you want the text to fit whatever width the column happens to be.
manual, and it stays put
Alt + Enter
Double-click the cell — “you can also select the cell, and then press F2” — put the
cursor where the line should break, and press Alt + Enter.
That break is a character in the cell. It does not move when the column does.
Right for anything with a shape of its own: an address, a two-line heading, a name over a job title.
The test is whether the line breaks belong to the content or to the column. A description can break anywhere and should reflow — that is Wrap Text. An address has lines that mean something, and they should stay where you put them regardless of how wide the column is — that is Alt + Enter. Using the first where you needed the second is invisible until the day somebody resizes a column and the address comes out as one run of words.
“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.”
Microsoft, read 22 August 2026 — and this single sentence answers the complaint behind this question. You pressed Wrap Text, the button lit up, and nothing changed. It did work. The text is wrapped and you cannot see it, because something is holding the row at a height that will not grow.
The second cause is the more troublesome one, and it is the reason merged cells cause problems across the whole of Excel. A merged range does not behave like a cell when the row needs to resize, so wrapping inside one is unreliable in a way that no setting fixes — the fix is not to merge.
Making the row grow
Why merged cells keep appearing in these answers. Merging is the most common thing people do to make a spreadsheet look tidy, and it is the thing that quietly breaks the most: wrapping, sorting, filtering and copying all behave differently across a merged range. If a heading needs to sit across several columns, Center Across Selection in the alignment options gives the same appearance without merging anything, and nothing downstream breaks.
One thing to know before you rely on the manual break. The character Alt + Enter inserts stays in the cell, so it travels with the data — into a CSV, into a mail merge, into whatever reads the file next. That is exactly what you want for an address arriving on a printed letter, and exactly what you do not want in a column somebody will later match, sort or look up, because the value is no longer a single line of text.
The same spreadsheet opened somewhere else keeps the wrapping, and changes the keys. LibreOffice Calc stores the same two things and calls them almost the same: “In Format - Cells - Alignment, mark the Wrap text automatically option”. The manual break is a different shortcut there — “Pressing the Command Ctrl +Enter keys inserts a manual line break” — and its help page ends with a warning that is Microsoft’s second cause in other words: “For automatic wrapping in XLS files, the rows in question should be set to Optimal Height.” Two programs, two vocabularies, the same row height deciding what you see.
And if the column is simply too narrow, the answer may be neither. Widening the column, or using Shrink to Fit in the alignment options, keeps the row one line high — which matters when the sheet has to print, because wrapped rows grow and a table that fitted on one page stops fitting.
The two routes, the note about wrapping following the column width, the two causes of invisible wrapped text and the row height options are quoted from Microsoft’s own Excel documentation, read on 22 August 2026 and listed below. The test for which method suits which content, and the warning about the line break travelling with the data, are ours.
Four ways in.
One reflows with the column and one stays where you put it. Which you want depends on whether the line breaks mean anything.
Microsoft names both causes in one sentence, and one of them is the reason merged cells cause trouble everywhere else too.
Wrapping changes the shape of the sheet, which matters most at the moment it has to print or be sent.
A manual line break is a character in the cell, so it travels with the value into whatever reads the file next.
You cannot: wrapping and row height are the same mechanism. Microsoft Learn puts it plainly — Excel “will change the row height of the range, if necessary, to accommodate the text”. If the height must not move, use a manual break with Alt + Enter and set the row height yourself, or widen the column.
Microsoft documents two causes and no others: “the row is set to a specific height” or “the text is in a range of cells that has been merged”. The first is fixed with AutoFit Row Height. The second is only fixed by unmerging.
Double-click the cell — or select it and press F2 — put the cursor where the break belongs, and press Alt + Enter. The break is stored in the cell, so it survives a change of column width, and it also travels into any file you export.
Because the range is mixed. Excel answers that question with three values, not two: True when every cell wraps, False when none does, and Null “if the specified range contains some cells that wrap text and other cells that don’t”.
Not covered here. It will not describe only the button. There are two ways to break a line in a cell and they behave differently the moment somebody resizes a column.
It will not leave you thinking Wrap Text failed. Microsoft names both reasons the text stays invisible, and they are quoted here.
And it will not suggest merging cells to tidy the layout, because that is one of the two reasons wrapping breaks. What holds instead is simple: the two causes of invisible wrapped text and the row height options are Microsoft’s own, quoted with the date it was read.
The order the work actually happens in: the data arrives, it gets cleaned, it gets counted, it gets a chart, and then somebody else opens it.
What to do to a sheet before it leaves your hands, and how to undo what arrived.
Written by Alberto Gulotta
Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.
Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.
Written on 22 August 2026 · last checked 23 September 2026.
Independence and limits
No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.
This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.