How to Display All Text in a Wrapped Excel Cell
Question details
The user needs to display all text in a wrapped Excel cell when the row is too short.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A cell contains text wrapped across multiple lines, but the row height does not accommodate all of it.
- Observed behavior
- Some of the wrapped text is not visible in the cell.
Select the affected cell and check that Home > Wrap Text is enabled. Check whether the cell is merged, as AutoFit may not adjust the row height correctly for merged cells.
AutoFit the Row Height in Excel
Use AutoFit to expand the row to fit wrapped text automatically.
Click the row number on the left, or select the affected cell.
On the Home tab, select Format > AutoFit Row Height.
Confirm that all lines are visible. If needed, select the cell and turn on Home > Wrap Text.

Adjust the Excel Row Height Using the Row Header
Use the row boundary for a quick automatic fit or a manual adjustment.
Show Wrapped Cell Text in WPS Spreadsheet
Open your workbook in WPS Spreadsheet, enable wrapping, and adjust the row height to reveal the full cell contents.
- 1. Open the workbook: In WPS Spreadsheet, select Open and choose your Excel workbook.
- 2. Enable text wrapping: Select the affected cell, then choose Home > Wrap Text.
- 3. Fit the row: Double-click the lower boundary of the row number to fit the row to its contents.
- 4. Adjust manually if needed: If text remains hidden, drag the row's lower boundary downward until all lines are visible.

Frequently Asked Questions
Why is some text hidden even though Wrap Text is enabled?
The row may be too short to display every line. Select the row and choose Home > Format > AutoFit Row Height, or increase the height manually.
Can I AutoFit a row without using the ribbon?
Yes. Double-click the lower boundary of the row number on the left side of the worksheet.
Why doesn't AutoFit show all the text in a merged cell?
AutoFit may not adjust row height correctly for merged cells. Drag the lower boundary of the row header downward to make the text visible.
How do I keep cell text on multiple lines?
Select the cell and make sure Home > Wrap Text is enabled. Then adjust the row height if any lines remain hidden.




