Wrap Text vs Shrink to Fit in Excel
By Mark Fulton · 2026-09-17 · 9 min read
Use Wrap Text (Home > Alignment > Wrap Text) when a cell holds a sentence people need to read, and let the row grow with Home > Cells > Format > AutoFit Row Height. Use Shrink to Fit (Format Cells > Alignment > Shrink to fit) only for a value slightly too wide for a column whose width can't change. Widen the column when the text is short and consistently long. Past three or four wrapped lines, move the text out of the cell. If wrapped text stays cut off, the row either has a height someone set by hand or the text sits in merged cells. AutoFit Row Height fixes the first. Only unmerging or a helper cell fixes the second.
Each option moves the damage somewhere else: into row height, font size, table width, or out of the grid. I tested every behaviour below in Excel for Microsoft 365 on Windows with the default Aptos Narrow 11 font, so the numbers are measured.
Wrap, shrink, widen or move it: which fits which job?
| Option | Readability | Print behaviour | Row height side effect | When it's correct |
|---|---|---|---|---|
| Wrap Text | Good for a sentence or two, poor past four lines | Prints what the row height shows. A fixed or merged row prints cut off | Row grows with the text, unless the height was set by hand or the cell is merged | Notes and descriptions that belong to one record |
| Shrink to Fit | Poor on long text, and cells in one column end up different sizes | Prints at the reduced size, often too small to read | None. The font shrinks instead | A value slightly too wide for a column fixed by a form or print layout |
| Widen the column | Best for short values at full size | Pushes other columns toward a second page | None | Names, emails and labels that are consistently a little long |
| Move the text out | Best for long text, and the table stays scannable | Table prints cleanly, notes print where you put them | None | Paragraphs, commentary, anything read once rather than scanned |
Underneath all four is the default. Text spills into the next cell only while that cell is empty. Once the neighbour gets a value, the overflow is cut off at the border.
Why doesn't AutoFit Row Height work after wrapping?
Usually it does. A row is in one of two modes, and nothing on screen says which.
Automatic height. A row nobody has resized follows its contents. A 120 character note in a column 30 wide sat at 15 points. When I turned on Wrap Text, the row grew to 60.25 points, four lines, with no AutoFit command. When I shortened the note, it dropped back to 15 on its own.
Fixed height. Once a height is set, by typing a Row Height or dragging the border below the row number, Excel stops managing the row. I set a row to 15, turned on wrap and typed the same note. It stayed at 15, one line showing. Microsoft's wrap text instructions give this as the first reason wrapped text isn't fully visible.
The fix hands the row back to Excel: select the rows, then Home > Cells > Format > AutoFit Row Height, or double-click the boundary below a row number. My fixed row went from 15 to 60.25. To reset a whole sheet, click Select All (the corner above row 1) and double-click any row boundary.
When AutoFit Row Height "doesn't work", it's usually one of three things:
- The row was resized at some point. Even an accidental drag locks the height. Run AutoFit Row Height once and the row follows its text again.
- The row is too tall, not too short. AutoFit sizes the row to its tallest wrapped cell, wherever it sits. When I added a wrapped copy of the note in a column 12 wide, the row jumped to 150.5 points because that narrow column needed ten lines. Widen that column or turn its wrap off.
- The text is in merged cells. AutoFit can't fix that one at all.
How do merged cells break row height?
The same Microsoft page names merged cells as the other reason wrapped text gets cut off. In practice, AutoFit Row Height ignores wrapped text inside a merged range.
I merged two columns 15 wide into one cell 30 wide, turned on wrap and entered the same note. The row stayed at 15, and AutoFit Row Height left it at 15. The identical note in a single unmerged cell 30 wide autofit to 60.25.
AutoFit doesn't size a row to text spread across a merged span. Three fixes, in order of preference:
- Unmerge. If the merge only makes a wider cell for a note, unmerge, widen one column and wrap there. For headings, Center Across Selection gives the same look without a merge. The full routine is in what to use instead of merged cells.
- Use a helper cell. When the merge has to stay, pick a spare column in the same row, set its width to the combined width of the merged columns, enter a formula pointing at the merged cell (such as
=B4) and turn on wrap. AutoFit now has an unmerged cell to measure. In my test that took the row from 15 to 60.25, and it still worked with the helper column hidden. - Set the height by hand. Fine for a one-off, but it's a fixed height. If the text changes, the row won't follow.
When is Shrink to Fit ever the right answer?
Rarely, but it has a real job. Open Format Cells (Ctrl+1 on Windows, Cmd+1 on Mac), go to the Alignment tab and tick Shrink to fit. Microsoft's description of Shrink to fit is exact: the text reduces to fit the column width, and keeps adjusting if the width or the content changes.
It's display only: with Shrink to Fit on a long note, the font size still read 11, so nothing warns a later editor. And it works cell by cell, so a column of mixed lengths ends up in several text sizes.
Where it earns its place is numbers. A currency column 6 wide showed $1,234,567.89 as ######. With Shrink to Fit on, the full amount appeared, slightly smaller. On an invoice or print template where the width isn't yours to change, that beats hash marks. On a normal data sheet, give the column a width that fits, as covered in setting column widths and row heights properly.
What row height should wrapped text get?
Let AutoFit set it, then judge the result in lines, not points. With the default font a wrapped line takes about 15 points, so a four-line note lands at 60.25.
- One or two lines: leave it.
- Three or four lines: fine for a notes column, with the rest of the row top aligned so short values don't float mid-row.
- Five or more: the row is taller than several neighbours combined, and readers lose their place. The text should leave the cell.
Capping a tall row by typing a height, say 60 points, turns it into a fixed row. Anything past the cap is hidden, including future edits. Use a cap only on a finished, read-only report.
There's also a hard ceiling of 409 points. When I autofit a wrapped cell holding a very long passage, the row stopped at that limit, however much text was left.
When should long text leave the cell entirely?
The ribbon doesn't offer this one, but it's often right. A cell is built for a value you scan, sort and compare. A paragraph isn't that.
Move text out when:
- It routinely runs past four wrapped lines. A table should look planned, not grown, the principle behind how to make an Excel spreadsheet look professional.
- Only some rows have it. A mostly empty column with the odd paragraph wastes width on every row. A notes tab keyed by the same ID, or a notes block under the table, keeps the table even.
- It's context, not data. Where a figure came from reads better as a cell note on that figure than as a column.
- The sheet will be printed. Tall wrapped rows push a table onto extra pages unpredictably. Printing an Excel sheet on one page is easier once long text is out of the grid.
How does this behave in Google Sheets?
Sheets has the same choice with one option missing. Its text wrapping settings are Overflow, Wrap and Clip: Overflow behaves like Excel's default, Wrap grows the row, and Clip cuts text at the border without spilling. There's no Shrink to Fit. Google's formatting help for Sheets lists wrap text among the cell formatting options and nothing that shrinks text to fit.
To size rows, right-click the row number, choose Resize row and pick Fit to data, or double-click the row's edge.
What does SuperSheet do with long text?
The formatter applies these rules for you. A column whose content would need more than 34 characters stops at 34 and wraps, top aligned. Body rows are written without a fixed height, so they stay automatic: a file written the same way opened in Excel with the wrapped four-line note already at 60.25 points, no AutoFit needed. It never uses Shrink to Fit, and it doesn't unmerge or restructure cells in your data, so a merged range causing cut-off text is still yours to fix with the steps above.
Any step in the plan can be switched off before you apply it, and the chat rail can change a column's width or wrap. Run the sheet through the Excel formatter and compare its row heights with your original. It's free, the file is never uploaded, and your original stays untouched.
FAQ
Why won't my row expand with wrapped text?
The row has a fixed height or the text is in merged cells. If anyone set or dragged that row's height, Excel stops resizing it: select the row and choose Home > Cells > Format > AutoFit Row Height. If the cell is merged, AutoFit ignores it, so unmerge or add an unmerged helper cell in the same row that repeats the text at the same total width.
Is Shrink to Fit bad practice?
On text, usually. Cells in one column end up different sizes, the font size box doesn't show the reduction, and long text becomes too small to read. On a number slightly too wide for a column you can't widen, it's a reasonable fix and better than ######.
How do I set a maximum row height?
Excel has no setting that caps AutoFit, only the 409 point ceiling. Typing a fixed height caps what's shown, but the row stops following its text and anything past the cap is hidden. If rows regularly need a cap, the text belongs in a notes tab or notes block.
Why does wrapped text print cut off?
Excel prints each row at the height it has, so a fixed height or merged cell that cuts text off on screen cuts it off on paper too. Run AutoFit Row Height, fix merged ranges, and check the preview under File > Print before sending.