How to Wrap Text in Excel (Plus Line Breaks That Stay Put)

Long product descriptions, client notes and addresses have a habit of spilling across the next three columns in Excel, or getting chopped off the moment you type in the cell beside them. Wrap Text fixes that by folding the words onto extra lines inside the same cell, so the column stays narrow and everything stays readable.

It's one button, but there are two other tricks worth knowing alongside it: forcing a new line exactly where you want it, and getting the row to grow tall enough to show it all. I'll cover all three.

Turning on Wrap Text in an Excel cell

According to Microsoft's help page, the button lives in the Alignment group on the Home tab.

1. Select the cell, or drag across a group of cells or a whole column.
2. Go to the Home tab.
3. In the Alignment group, select Wrap Text.

Your text now breaks onto new lines to fit the column width. Microsoft notes that if you later make the column wider or narrower, the text re-wraps on its own, so you don't need to redo anything.

Wrap Text works as an on and off switch. To unwrap, select the same cells and select the button again.

Adding a line break inside an Excel cell yourself

Wrap Text decides where the lines break based on the column width. When you want control, say, a name on one line and a job title on the next, insert a manual line break.

1. Double-click the cell, or select it and press F2, to start editing.
2. Click inside the text exactly where you want the new line.
3. Press Alt + Enter.
4. Press Enter to finish.

This is the trick I use most for addresses: street, town and postcode on separate lines in one cell, which looks tidy when you print a delivery list or copy it into a label.

When wrapped text in Excel is still cut off

Sometimes you switch on Wrap Text and the cell still shows only the first line. Microsoft's help gives two causes: the row has a set height, or the text sits in merged cells.

Letting the row height catch up

1. Select the row, or the cells in it.
2. On the Home tab, in the Cells group, select Format.
3. Under Cell Size, select AutoFit Row Height.

If you'd rather choose the height yourself, the same menu has Row Height, where you type a value. You can also drag the bottom border of the row number down until all the text shows. For the column side of the same job, my guide on making Excel columns fit their contents walks through the width controls.

Merged cells and wrapping

Merged cells are the usual culprit in templates you've inherited. Microsoft lists merged cells as one reason wrapped text doesn't fully show, and AutoFit often won't size a merged row the way you'd hope. Dragging the row border by hand is the quickest workaround, or unmerge the cells and use a wider single column instead.

Wrap Text compared with other ways to fit text in Excel

Wrap Text isn't the only way to stop text overflowing. Here's how I'd choose between the options:

Option	What it does	Good for
Wrap Text	Breaks text onto extra lines in the cell	Notes, descriptions, long labels
Alt + Enter line break	Starts a new line exactly where you choose	Addresses, name and title
Widening the column	Shows the text on one line	Short headings
AutoFit Row Height	Makes the row tall enough for wrapped text	Fixing cut-off wrapped text

For column headings, I'd use Wrap Text plus a slightly wider column. It keeps headers like "Date of last contact" readable without making the sheet wide enough to need sideways scrolling.

Wrapping text in Excel for business sheets and printouts

A few places where wrapping earns its keep for side-hustlers and small teams:

• Content calendars. Post captions and notes stay visible without each row becoming a mile wide.
• Product lists. Short descriptions sit neatly beside stock codes.
• Client trackers. Meeting notes fit inside a narrow notes column.
• Printed sheets. Wrapped cells keep everything on the page instead of running off the edge.

If you're building a list like that from scratch, turning it into an Excel table with filters and banded rows first makes the wrapped rows much easier to scan.

Wrapping text across a whole Excel sheet at once

You don't have to wrap cell by cell. Click the small triangle in the top-left corner where the row numbers meet the column letters to select the entire sheet, then select Wrap Text. Every cell now wraps to its column width. I'd only do this on sheets that are mostly notes, because short numbers in narrow columns can end up looking oddly tall once rows grow to fit the longest cell in each row.

If the Wrap Text button in Excel looks greyed out or does nothing

• Check you're not still typing in the cell. Press Enter or Esc first, then select Wrap Text.
• If the cell holds a number rather than text, it won't wrap the way words do, so widen the column instead.
• If the sheet is protected, formatting may be locked. Ask whoever set the protection, or unprotect it if it's your file.
• On a small screen, the ribbon may collapse the Alignment group into one button. Menus vary by window size and app version.

Frequently asked questions

How do I wrap text in Excel automatically?

Select the cells, then go to Home and select Wrap Text in the Alignment group. Microsoft says the text then re-wraps by itself whenever you change the column width.

What's the shortcut for a new line in an Excel cell?

Double-click the cell or press F2, click where you want the break, then press Alt + Enter. That inserts a line break at that exact point.

Why is my wrapped text still hidden?

Microsoft says the row may have a set height or the text may be in merged cells. Try Home, Format, AutoFit Row Height, or drag the row's bottom border down.

How do I turn Wrap Text off?

Select the wrapped cells and select Wrap Text again. It works as a toggle, so the text goes back to a single line.

Does wrapping text change what's in the cell?

No. Wrap Text only changes how the text is displayed. A manual Alt + Enter break does add a line break character to the text itself.