How to Wrap Text and Merge Cells in Excel

Applies to: Microsoft 365 (Excel for Windows, Excel for Mac, Excel for the web); Excel 2016, 2019, 2021
Article Type: How-To
Last Updated: 2026-07-29

Summary

Wrapping text keeps a long entry inside its own cell instead of letting it spill across the ones beside it. Merging cells joins several into one — and quietly breaks sorting, filtering, and half your formulas. This article covers both, plus the alternative that gives you the merged look with none of the consequences.

Prerequisites

• Excel for Windows, Excel for Mac, or Excel for the web. Where a feature is missing from the web version, the step says so.
• Edit permission on the workbook. No admin rights required.

Instructions

1. Wrap Text Inside a Cell

By default a long entry runs across its neighbours if they are empty, and is cut off at the cell edge if they are not. Wrapping keeps it inside its own cell on multiple lines.

1. Select the cell or cells. To wrap a whole column, click its column letter.
2. Click the Home tab on the ribbon.
3. In the Alignment group, click Wrap Text. The button stays highlighted while wrapping is on.
4. The text reflows onto as many lines as the column width needs, and the row grows taller to show them.

Verification: Widen the column by dragging the boundary between two column letters. Wrapped text reflows and the row height changes with it. Unwrapped text does not move at all.

Tip: Wrapped text sits at the bottom of a tall row by default, which looks wrong next to short rows. Select the range and click Top Align in the Alignment group on the Home tab to line every entry up along the top.

Note: Wrap Text is in the same place in Excel for the web — the Home tab, Alignment group.

2. Add a Line Break Exactly Where You Want It

Wrapping decides the line breaks for you, based on column width. When you need a break in a specific place — an address on three lines, a bullet list inside one cell — put it there yourself.

1. Double-click the cell to start editing it, or click the cell and press F2.
2. Click the point in the text where the new line should start.
3. Press Alt + Enter. On a Mac, press Control + Option + Enter.
4. Press Enter to confirm the cell. The text now breaks where you put the break, and Excel turns on Wrap Text for that cell automatically.

Note: In Excel for the web the shortcut is Alt + Enter on Windows and Option + Enter on a Mac. Some browsers intercept it — if nothing happens, edit the cell in the desktop app.

Tip: To strip manual line breaks out of imported data, press Ctrl + H to open Find and Replace, click in the Find what box, press Ctrl + J (the box looks empty but now holds a line break), leave Replace with blank or type a space, and click Replace All.

3. Fix a Row That Will Not Auto-Fit

Wrapped text that is cut off at the bottom of the row is the most common complaint about wrapping, and there are two causes.

The row height was set manually. Dragging a row boundary at any point in the past switches that row from automatic to fixed height, and it stays fixed no matter how much text you add.

1. Move your pointer over the boundary line directly under the row number in the grey row header on the left.
2. When the pointer becomes a double-headed arrow, double-click. The row snaps to fit its contents.
3. For several rows at once, select them by dragging down the row numbers, then click Home > Format in the Cells group > AutoFit Row Height.

The row contains a merged cell. Auto-fit ignores merged cells completely — this is a documented limitation, not a bug in your file.

1. Unmerge the cell using Step 6, then auto-fit works normally.
2. If the merge has to stay, drag the row boundary down by hand until the text is visible. You will have to redo it whenever the text changes.

Verification: Type a few extra words into a wrapped cell and press Enter. On a row with working auto-fit, the row grows as you commit the change.

4. Merge Cells with Merge & Center

Merging joins a block of cells into one. It suits a report title across the top of a printed page, and little else.

1. Select the cells you want to join. They must be next to each other.
2. On the Home tab, in the Alignment group, click Merge & Center.
3. If more than one of the selected cells contains something, a message warns that merging keeps only the upper-left value and discards the rest. Click OK to continue or Cancel to stop.
4. The block becomes one cell, and its content is centred across the full width.

Click the small arrow beside Merge & Center for the other options:

• Merge & Center — one cell, content centred.
• Merge Across — merges each selected row separately, so a three-row selection gives three merged cells rather than one.
• Merge Cells — merges without changing the alignment.
• Unmerge Cells — splits the block back apart.

Verification: Click the merged block. The Name Box to the left of the formula bar shows a single address, such as A1, rather than a range.

Note: The discarded values are gone, not hidden. Unmerging afterwards returns empty cells, not the content that was there. Press Ctrl + Z straight away if you merged over data by mistake.

5. Use Center Across Selection Instead

This is the setting that gives you a centred title spanning several columns while leaving every cell independent. On screen the result is indistinguishable from Merge & Center.

1. Type your title in the left-most cell of the range — cell A1 for a title spanning A1 to F1.
2. Select the full range, A1 through F1.
3. Press Ctrl + 1 to open the Format Cells dialog. On a Mac, press Command + 1.
4. Click the Alignment tab.
5. Open the Horizontal dropdown under Text alignment and choose Center Across Selection.
6. Click OK. The title is centred across all six columns.

Verification: Click cell C1, in the middle of the span. The Name Box reads C1 and the formula bar is empty — the cells are still separate, and the value lives in A1 alone. Sorting, filtering, and formulas all behave normally.

Note: Center Across Selection is not available in Excel for the web, which has no Format Cells dialog. Apply it in the desktop app; the formatting is saved with the file and displays correctly when the workbook is opened in the browser.

Tip: Where a genuine multi-row header block is needed — a title bar two rows deep — set the alignment with Center Across Selection for the columns and increase the row height for the depth. You get the layout without a single merged cell in the sheet.

6. Unmerge Cells and Find the Merges Already in a Sheet

Inherited workbooks hide merges in places you would not think to look, and each one is a future error message.

To unmerge cells you can see:

1. Select the merged block, or press Ctrl + A to select the whole sheet.
2. On the Home tab, click the arrow beside Merge & Center and choose Unmerge Cells.
3. The block splits back into individual cells. The value stays in the upper-left cell; the rest are empty.
4. To fill the blanks with the value that was there, select the range, press Ctrl + G, click Special, choose Blanks, and click OK. Type = followed by the up-arrow key, then press Ctrl + Enter to fill every selected blank from the cell above it.

To find merges hiding in a large sheet:

1. Press Ctrl + F to open Find and Replace.
2. Click Options to expand the dialog.
3. Click Format on the right. The Find Format dialog opens.
4. On the Alignment tab, tick Merge cells under Text control, then click OK.
5. Leave Find what empty and click Find All. Every merged cell in the sheet is listed at the bottom of the dialog with its address.
6. Click any result to jump to that cell.

Tip: Clear the format filter afterwards. Click Format > Clear Find Format, or your next search returns nothing and looks broken.

Troubleshooting

WARNING

Merged cells break the features you rely on most. Sorting refuses to run, filters return the wrong rows, Ctrl + Shift + Down stops at the merge, copy and paste fails with We can't do that to a merged cell, and lookups return nothing because the value sits in the first row of the block and the rest are empty. Use Merge & Center on presentation-only sheets, and Center Across Selection everywhere your data lives.

Symptom / Error	Potential Cause	Solution
Wrapped text is cut off at the bottom	Row height was set manually	Double-click the boundary under the row number, or use Home > Format > AutoFit Row Height — see Step 3.
The row will not auto-fit no matter what	The row contains a merged cell	Auto-fit ignores merged cells. Unmerge with Step 6 and switch to Center Across Selection.
This operation requires the merged cells to be identically sized	Merges inside the sort range	Select the range, unmerge it with Step 6, then sort. Full walkthrough: How to Sort and Filter Data in Excel.
We can't do that to a merged cell	Pasting into or over a merged range	Unmerge the destination cells first, paste, then reapply formatting.
Filtering skips rows or returns the wrong ones	Value stored only in the top row of a merge	Unmerge and fill the blanks down using the Go To Special method in Step 6.
VLOOKUP returns #N/A on rows that look filled	Merged rows hold the value once	Unmerge and fill down so every row carries its own value — see How to Use VLOOKUP in Excel.
Alt + Enter does nothing	Cell is not in edit mode	Double-click the cell or press F2 first. On a Mac, the shortcut is Control + Option + Enter.

Related Articles

• How to Sort and Filter Data in Excel
• How to Split Text into Columns in Excel
• How to Freeze Panes and Split Views in Excel
• How to Remove Duplicate Rows in Excel
• Understanding Excel Features — A Quick-Reference Guide to What Excel Can Do

Did this solve your problem?