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
| Goal | What to do |
|---|---|
| Wrap long text | Select the cells, then Home tab > Alignment group > Wrap Text |
| Start a new line | Double-click the cell, place the cursor, press Alt+Enter |
| Merge cells | Select the cells, then Merge & Center > Merge Cells |
| Unmerge cells | Click the arrow next to Merge & Center > Unmerge Cells |
Wrap text in a cell
- Select the cells you want to format.
- 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.
| Cause | Fix |
|---|---|
| The row has a fixed height | Use AutoFit Row Height or set a specific height |
| The text is in merged cells | Merged 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
- Double-click the cell, or select it and press F2.
- Place the cursor where you want the line to break.
- 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
- Select the cells you want to combine.
- 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
- Select the merged cell.
- Click the down arrow next to Merge & Center.
- Choose Unmerge Cells.
Unmerging separates the cells again, but it cannot bring back content that merging already deleted.
Find every merged cell
- On the Home tab, open Find & Select in the Editing group and choose Find.
- Click Format.
- On the Alignment tab, check Merge cells and click OK.
- 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
| Option | Where to find it |
|---|---|
| Top, Middle or Bottom Align | Home tab |
| Left, Center or Right alignment | Home tab |
| Indent, Orientation and degrees | Right-click > Format Cells > Alignment tab (Mac) |
| Undo an alignment change | Undo 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.
| Setting | How it works |
|---|---|
| Indent | Choose a left, right or distributed indent, then enter the number of characters |
| Vertical text | Select the vertical text box under Orientation to stack text top to bottom |
| Rotation | Drag the indicator under Orientation or enter an angle in Degrees |
| Reset | Set 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.
Related Excel guides
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.