Docs tower · floor
Excel has two ways to put text on more than one line inside a cell, and Microsoft names both in its first sentence: “You can format the cell to wrap the text automatically or enter a manual line break.” Most pages answering how to wrap text in excel describe only the first, which is why so many spreadsheets contain addresses that rearrange themselves whenever somebody widens a column.
automatic, and it reflows 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 Double-click the cell — “you can also select the cell, and then press 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.Wrap Text
Alt + Enter
F2” — put the
cursor where the line should break, and press Alt + Enter.
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.
Microsoft, read 22 August 2026 — and this single sentence answers the complaint that brings most
people to 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.“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.”
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.
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.
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 routes, the two causes of invisible wrapped text and the row height options are quoted from Microsoft’s own Excel documentation, with the date it was read.
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.
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.