Formatting Issues

Fix Wrapped Text and Row Height in Merged Excel Cells

Chanuka GeekiyanageChanuka Geekiyanage Nov 18, 2026 870 views

Question details

Show all wrapped text in merged Excel cells by adjusting the row height or changing the cell layout.

Fix Wrapped Text and Row Height in Merged Excel Cells
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet uses merged cells to display text across a larger area.
Observed behavior
Wrapped text is not fully visible because Excel does not reliably autofit row height for merged cells.
Before you start

Select the affected merged cell and check whether Wrap Text is enabled on the Home tab. Note whether the cells are merged across columns, rows, or both before changing the layout.

Solution 1Recommended

Manually increase the height of the merged cell's row

Use this method when the cells must remain merged.

1
Enable text wrapping

Select the merged cell, then choose Home > Wrap Text.

2
Increase the row height

Drag the lower edge of the row number downward until all text is visible. If the merged area spans multiple rows, adjust the relevant row heights as needed.

3
Set an exact height if needed

Select the row, then choose Home > Format > Row Height and enter a larger value.

Manually increase the height of the merged cell's row
AutoFit limitation: Excel does not reliably AutoFit row height for merged cells. Check the height again if the text or column widths change.
Free Microsoft Office alternative

Edit spreadsheets with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Its Microsoft Office format compatibility makes it easy to bring existing files into your workflow, although it does not change Excel's merged-cell behavior.

Work with spreadsheet cell formatting and wrapped textOpen and edit Microsoft Excel formats such as XLSX and XLSUse a familiar, easy-to-navigate interfaceMove existing Office files into a lightweight workspace
microsoft office alternative - wps office

Frequently Asked Questions

Why does AutoFit not show all text in my merged Excel cell?

Excel does not reliably calculate AutoFit row height for merged cells. Select the row and drag its lower boundary downward, or use Home > Format > Row Height.

How do I turn on Wrap Text for a merged cell?

Select the merged cell and choose Home > Wrap Text. If some text remains hidden, increase the row height manually.

Can I center text across columns without merging cells?

Yes. Select the range, open Format Cells > Alignment, and choose Center Across Selection under Horizontal. This does not replicate a vertical merge.

How do I AutoFit a row after unmerging cells?

Select the merged cell and choose Home > Merge & Center > Unmerge Cells. Then double-click the lower edge of the row number to AutoFit the row.