Business & Productivity · Guide
How to wrap text in Excel
Alt+H+W wraps text in the selected cells. Then comes the part that trips people: making the row height follow along, and knowing when to use a line break instead.
The Nextversity teamBusiness & Productivity schoolUpdated August 10, 20265 min read
On this page
The short answer
Select the cells and press Alt + H + W on Windows, or click Wrap Text on the Home tab. The text now flows onto extra lines inside the cell instead of spilling across its neighbors.
If you want the break in a specific place rather than wherever the column edge falls, put the cursor there and press Alt+Enter instead.
Wrapping versus line breaks
These are two different tools that look similar.
Wrap Text is automatic. Excel decides where the lines break based on the column width, and it re-flows when you resize the column. Use it for notes, descriptions and long labels.
Alt+Enter is manual. You choose the break point and it stays there whatever the column width does. Use it for addresses, or a label like Q3 revenue over (excluding tax).
You can use both in the same cell. The manual breaks are respected and the wrap handles the rest.
Fixing the row height
The most common complaint after wrapping is that the row does not grow, so the text is cut off.
That happens because the row height has been set manually at some point, which turns off auto-fit. Three fixes:
- Double-click the boundary below the row number in the row header. That restores auto-fit for that row.
- Select the rows, then Home > Format > AutoFit Row Height.
- Select all rows (click the corner box above row 1), then AutoFit Row Height, to reset the whole sheet.
If the row still refuses to grow, the cell is merged. Merged cells never auto-fit their height, and there is no setting to change it. Drag the row taller by hand, or stop merging: Center Across Selection gives the same look without the side effects.
The three related settings
Format Cells (Ctrl+1) has an Alignment tab with three options that people confuse:
- Wrap text: flows onto more lines, row gets taller.
- Shrink to fit: shrinks the font until the text fits on one line. Fine for a single cell, unreadable across a table.
- Vertical alignment: set this to Top on wrapped cells. Excel defaults to bottom alignment, which looks wrong once one cell has four lines and its neighbor has one.
That last one is the small change that makes a wrapped table look deliberate rather than accidental.
Cleaning up imported text
Text pasted from a website or an email often arrives with breaks you did not ask for.
- Find and replace a line break: Ctrl+H, click into Find what, press Ctrl+J (it looks like nothing happens, but the break character is in there), leave Replace with empty or type a space, and Replace All.
- Remove non-printing characters:
=CLEAN(A2)strips them out. - Remove stray spaces:
=TRIM(A2)handles leading, trailing and doubled spaces.
Do the cleaning before you format. Formatting messy text just gives you tidier mess. Microsoft's Excel support documents the text functions, and Microsoft Learn has guided modules if you want to practice them.
When a spreadsheet is the wrong container
If a column holds paragraphs, ask what the spreadsheet is for. Long notes belong in a document or a database field, not in a cell that has to be four lines tall to be readable. A common fix is a short code in the sheet and the detail somewhere else, linked by an ID.
That is the point where people move to Notion or Airtable for the record keeping and keep Excel for the numbers.
Where this fits in learning Excel
Wrapping text is a two-second job that no one should need a course for. It is on this list because badly wrapped tables are one of the reasons spreadsheets get called unreadable, and the fix is quick.
If you want the whole skill in order, the introduction course starts from a blank sheet and the Excel certificate covers the reporting half. Both sit in the Business & Productivity school on one subscription.
Wrap the text, top-align the cells, and let the row auto-fit. Three settings, and the table finally looks like someone made it on purpose.
Questions people ask
What is the shortcut for wrap text in Excel?
Alt then H then W on Windows. On Mac, use the Wrap Text button on the Home tab, or Command+Option+Return inside a cell to insert a line break at the cursor.
How do I start a new line inside a cell?
Press Alt+Enter where you want the break (Control+Option+Return on Mac). That is a manual line break, which is different from wrapping and gives you exact control.
Why is my row not getting taller after wrapping?
The row has a manually set height, which stops it auto-fitting. Double-click the boundary below the row number to reset it, or use Home, Format, AutoFit Row Height.
Why does wrap text do nothing on my cell?
The cell is probably merged. Merged cells do not auto-fit their height, so you have to drag the row taller by hand. This is one more reason to prefer Center Across Selection over merging.
How do I remove wrapping?
Select the cells and click Wrap Text again to toggle it off. If manual Alt+Enter breaks remain, remove them with Find and Replace using Ctrl+J in the Find box, which stands for the line break character.