Formatting Issues

How to Display All Text in a Wrapped Excel Cell

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

The user needs to display all text in a wrapped Excel cell when the row is too short.

How to Display All Text in a Wrapped Excel Cell
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.
Before you start

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.

Solution 1Recommended

AutoFit the Row Height in Excel

Use AutoFit to expand the row to fit wrapped text automatically.

1
Select the affected row

Click the row number on the left, or select the affected cell.

2
Apply AutoFit

On the Home tab, select Format > AutoFit Row Height.

3
Check the wrapped text

Confirm that all lines are visible. If needed, select the cell and turn on Home > Wrap Text.

AutoFit the Row Height in Excel
Merged cells: AutoFit may not work as expected for merged cells. If text is still hidden, increase the row height manually.
WPS Spreadsheet

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. 1. Open the workbook: In WPS Spreadsheet, select Open and choose your Excel workbook.
  2. 2. Enable text wrapping: Select the affected cell, then choose Home > Wrap Text.
  3. 3. Fit the row: Double-click the lower boundary of the row number to fit the row to its contents.
  4. 4. Adjust manually if needed: If text remains hidden, drag the row's lower boundary downward until all lines are visible.
Display wrapped text across multiple linesQuickly fit or manually resize rowsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.