Formatting Issues

AutoFit Excel Row Height After Pasting Text

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Fit Excel row height to text pasted from another cell or a Word document.

AutoFit Excel Row Height After Pasting Text
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.
Before you start

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.

Solution 1Recommended

AutoFit selected Excel rows using the row headings

Use this quick method to resize one or more rows to fit their contents after pasting.

1
Select the affected rows

Click the row heading on the left of the worksheet, or drag across multiple row headings to select all affected rows.

2
Find the row boundary

Move the pointer over the bottom boundary of a selected row heading until the row-resize cursor appears.

3
Fit the row height

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.

AutoFit selected Excel rows using the row headings
Merged cells: Excel may not AutoFit row height for merged cells. If necessary, drag the row-heading boundary to set the height manually.
Fit pasted text in WPS Spreadsheet

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. 1. Open the spreadsheet: In WPS Spreadsheet, open the XLS or XLSX file and locate the pasted text.
  2. 2. Wrap the text if needed: Select the cells and choose Home > Wrap Text if the content needs to appear on multiple lines.
  3. 3. Select the rows: Click or drag across the affected row headings on the left side of the sheet.
  4. 4. AutoFit the rows: Double-click the bottom boundary of a selected row heading when the resize cursor appears.
Quickly resize rows after pasting textOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interfaceWork with a free, easy-to-use office suite
microsoft office alternative - wps office

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.