How to copy row height in excel

Answer

To copy row height in Excel, follow these steps:

1. Select the row with the desired height
   Click on the row number on the left to highlight the entire row whose height you want to copy.

2. Copy the row
   Press Ctrl + C on Windows or Command + C on Mac to copy the row.

3. Select the target row(s)
   Click on the row number(s) where you want to apply the same height. You can select multiple rows by dragging or holding Ctrl (Windows) / Command (Mac) while clicking.

4. Paste row height only

   • Right-click the selected row(s).

   • Choose Paste Special.

   • In the dialog box, select Row Heights and click OK.

The target rows will now have the same height as the copied row without changing the cell content or formatting.

Alternative Method Using Format Menu

1. Select the row with the desired height.

2. Go to the Home tab.

3. Click Format in the Cells group.

4. Choose Row Height… and note the value.

5. Select the target row(s), go to Format → Row Height…, and enter the same value.

This method works well when copying row height across sheets or different workbooks.

Tips

• You cannot directly drag the row height like the fill handle; you must use Paste Special → Row Heights.

• For multiple non-contiguous rows, repeat the steps or manually enter the height via the Format menu.

• Copying row height preserves uniformity in tables, reports, and dashboards.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report