Fix Wrapped Text and Row Height in Merged Excel Cells
Question details
Show all wrapped text in merged Excel cells by adjusting the row height or changing the cell layout.

- 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.
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.
Manually increase the height of the merged cell's row
Use this method when the cells must remain merged.
Select the merged cell, then choose Home > Wrap Text.
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.
Select the row, then choose Home > Format > Row Height and enter a larger value.

Unmerge cells and use Center Across Selection
Use this approach to keep text centered across columns without merging the cells.
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.

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.




