AutoFit Excel Row Height After Pasting Text
Question details
Fit Excel row height to text pasted from another cell or a Word document.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Text has been pasted into a worksheet, and the user wants the affected rows to fit their contents.
- Observed behavior
- A row may retain its previous height after text is pasted, leaving some content out of view.
Select the cells containing the pasted text and turn on Home > Wrap Text if the text needs to appear on multiple lines. Check whether the affected cells are merged, because Excel may not AutoFit their row height.
AutoFit selected Excel rows using the row headings
Use this quick method to resize one or more rows to fit their contents after pasting.
Click the row heading on the left of the worksheet, or drag across multiple row headings to select all affected rows.
Move the pointer over the bottom boundary of a selected row heading until the row-resize cursor appears.
Double-click the boundary to AutoFit the selected rows. If text still appears on one line, select the cells and choose Home > Wrap Text, then AutoFit the rows again.

Use the AutoFit Row Height command in Excel
Use the ribbon command when you prefer a menu option over double-clicking row boundaries.
AutoFit row height in WPS Spreadsheet
Open your spreadsheet in WPS Spreadsheet and use the row-heading boundary to fit rows to pasted text.
- 1. Open the spreadsheet: In WPS Spreadsheet, open the XLS or XLSX file and locate the pasted text.
- 2. Wrap the text if needed: Select the cells and choose Home > Wrap Text if the content needs to appear on multiple lines.
- 3. Select the rows: Click or drag across the affected row headings on the left side of the sheet.
- 4. AutoFit the rows: Double-click the bottom boundary of a selected row heading when the resize cursor appears.

Frequently Asked Questions
Why doesn't Excel resize the row when I paste text?
A row can retain its existing height after a paste. Select the affected row and double-click its bottom boundary, or choose Home > Format > AutoFit Row Height.
How do I make long text appear on multiple lines?
Select the cells and choose Home > Wrap Text. Then AutoFit the affected rows using Home > Format > AutoFit Row Height.
Can I AutoFit several rows at once?
Yes. Drag across their row headings, then double-click the bottom boundary of a selected row heading to fit the selected rows.
Why isn't AutoFit working for a merged cell?
Excel may not AutoFit the row height of merged cells. Drag the bottom boundary of the row heading to set a height that displays the text.




