Excel Tutorials
Show long notes and descriptions on multiple lines inside a single cell, without widening the column. This lesson uses the Event Planner workbook from Excel Foundations, free to download below.
Follow along in the same file used in the video. No email required.
Wrap Text makes long content inside a cell display across multiple lines rather than spilling over into neighboring cells or getting cut off. The row height adjusts automatically so every line of the wrapped text stays visible.
It's the most common fix for cells holding notes, descriptions or addresses, anything longer than a short label, without forcing you to make the column uncomfortably wide.
Step-by-step, matching the video above.
Click a single cell, or select a range if you want to apply it to several at once.
Go to the Home tab on the ribbon.
In the Alignment group, click Wrap Text. Long content immediately breaks onto multiple lines within the cell.
Excel automatically grows the row to fit every wrapped line. If the row was manually resized before, you may need to widen it yourself.
Wrap Text works within whatever width the column already has, widening the column changes how many lines the text needs.
Click Wrap Text again to toggle it off, text returns to spilling over or getting cut off by the next cell.
These solve similar problems in different ways, and mixing them up leads to confusing results.
Excel decides where each line breaks based on the column's current width. Widen the column and the line breaks move.
While typing in a cell, press Alt+Enter to force a line break at your cursor, regardless of column width.
Use Wrap Text for a paragraph that should flow naturally. Use Alt+Enter for something like an address, where you always want the street on one line and the city on the next.
If someone previously dragged the row to a fixed height, Wrap Text won't override it. Double-click the row boundary to auto-fit it again.
Wrap Text behaves unpredictably on merged cells, since the wrapped content only really belongs to the top-left cell of the merge.
Taller wrapped rows can shift where a page break falls. Check Print Preview after wrapping a lot of text.
Long notes shouldn't need a formatting trick to be readable.
Free 14-day trial. No credit card required.
Select the cell, go to the Home tab, and click Wrap Text in the Alignment group. The content breaks onto multiple lines and the row grows to fit it.
The row was likely resized manually at some point. Double-click the row number's bottom boundary to auto-fit it to the wrapped content.
Wrap Text lets Excel decide where lines break based on column width. Alt+Enter forces a line break at an exact spot you choose while typing.
No. It only changes how the text displays, the underlying value in the cell is unchanged.
Yes. Select the whole range first, then click Wrap Text once to apply it to every selected cell.
Wrap Text only really applies to the top-left cell of a merge, which can cause uneven results. Consider Center Across Selection instead of merging if this becomes a problem.
Select the cell and click Wrap Text again, it's a toggle. The text returns to spilling over or being cut off.
Yes, Google Sheets has its own Wrap toggle in the toolbar with the same basic behavior, though it labels the options Overflow, Wrap and Clip.
Every business starts with a spreadsheet. Updoot is where you scale past it, notes and updates already display clean.
Start Your Free Trial →