How To Wrap Text And Merge Cells In Excel (2026)

Long text in an Excel cell either runs off into the next column or gets cut off, and neither looks right in a finished sheet.

Wrap Text keeps the words inside the cell, and Merge & Center joins cells so a title can stretch across a table.

Here is how to use both, how to fix wrapped text that still looks cut off, and how to find and unmerge cells.

Quick answer: wrap text or merge cells

GoalWhat to do
Wrap long textSelect the cells, then Home tab > Alignment group > Wrap Text
Start a new lineDouble-click the cell, place the cursor, press Alt+Enter
Merge cellsSelect the cells, then Merge & Center > Merge Cells
Unmerge cellsClick the arrow next to Merge & Center > Unmerge Cells

Wrap text in a cell

  1. Select the cells you want to format.
  2. On the Home tab, in the Alignment group, select Wrap Text.

Wrapped text fits the column width, so it wraps again whenever you change the width of the column.

If wrapped text is still hidden

Microsoft gives two reasons that wrapped text can stay cut off.

CauseFix
The row has a fixed heightUse AutoFit Row Height or set a specific height
The text is in merged cellsMerged cells can prevent proper wrapping, so unmerge them

Adjust the row height

For automatic sizing, select the cells and go to Home > Cells group > Format, then choose AutoFit Row Height under Cell Size.

For manual sizing, choose Row Height in the same menu and enter a value, or drag the bottom border of the row until all the text shows.

Start a new line inside a cell

  1. Double-click the cell, or select it and press F2.
  2. Place the cursor where you want the line to break.
  3. Press Alt+Enter.

Microsoft says this also adds spacing between lines or paragraphs in a cell, and it applies to Excel for Microsoft 365 and Excel 2016 through 2024.

Wrap text in Excel for Mac

The steps are the same on a Mac: select the cells and click Wrap Text on the Home tab.

If not all the text shows, open the Format menu, go to Row, and choose AutoFit, or use Home > Format > Auto-fit Row Height.

To start a new line in a cell on a Mac, double-click the cell, place the cursor and press Control-Option-Return.

Shrink text to fit instead

If you would rather keep the text on one line, Shrink to fit reduces the font to match the column width.

On a Mac, select the cells, right-click, choose Format Cells, and check Shrink to fit on the Alignment tab.

The font adjusts as you resize the column or add more data.

Widen the column instead

Hover over the divider on the right edge of the column header and drag it, or double-click that divider to auto-fit the column to its contents.

Microsoft’s Mac page also lists a smaller font size on the Home tab as a way to fit text that is cut off.

Merge cells

  1. Select the cells you want to combine.
  2. On the Home tab, click Merge & Center, then choose Merge Cells.

Only the content of the upper-left cell survives in a left-to-right language, and the contents of the other cells are deleted.

In a right-to-left language, the upper-right cell’s content is kept instead.

Merge & Center for titles

Microsoft describes Merge & Center as the way to center text across several adjacent columns or rows.

It suits a title above a table, where one cell needs to span every column below it.

Unmerge cells

  1. Select the merged cell.
  2. Click the down arrow next to Merge & Center.
  3. Choose Unmerge Cells.

Unmerging separates the cells again, but it cannot bring back content that merging already deleted.

Find every merged cell

  1. On the Home tab, open Find & Select in the Editing group and choose Find.
  2. Click Format.
  3. On the Alignment tab, check Merge cells and click OK.
  4. Click Find All.

Excel lists every merged cell in the worksheet, and selecting an item in the list takes you to that cell so you can unmerge it.

In Excel for the web, a cell is merged if Merge and Center is highlighted in the Alignment group when you select it.

Why you cannot split a cell

Microsoft states that you cannot split a single cell, and you can only make a cell look split by merging the cells above it.

To spread one cell’s text across several columns, use our guide to splitting text into columns in Excel.

Other alignment options

OptionWhere to find it
Top, Middle or Bottom AlignHome tab
Left, Center or Right alignmentHome tab
Indent, Orientation and degreesRight-click > Format Cells > Alignment tab (Mac)
Undo an alignment changeUndo right away, or Clear > Clear Formats later

Clear Formats removes all other formatting too, not just the alignment.

Microsoft notes that Excel for the web cannot rotate text inside a cell.

Indent and rotate text in a cell

Microsoft’s Mac page puts these settings on the Alignment tab of Format Cells, which opens when you right-click the cells.

SettingHow it works
IndentChoose a left, right or distributed indent, then enter the number of characters
Vertical textSelect the vertical text box under Orientation to stack text top to bottom
RotationDrag the indicator under Orientation or enter an angle in Degrees
ResetSet horizontal alignment back to General

Fill and Center Across Selection do not support rotation, and some older Excel versions only handle 90, 0 and -90 degrees.

To join the contents of two cells without losing either one, see combining text from two cells in Excel.

If a column shows ##### instead of your data, read about dates showing as numbers or hashes.

Once your text fits, you can sort and filter the data in the same sheet.

Sources

Steps come from Microsoft’s pages Wrap text in a cell in Excel and Merge and unmerge cells in Excel.

The Find steps come from Microsoft’s Find merged cells page.

Leave a Reply

Your email address will not be published. Required fields are marked *