How to Copy Row Height in Excel & Google Sheets

This tutorial demonstrates how to copy row height in Excel and Google Sheets.

In Excel, you can copy column widths with Paste Special, but this functionality doesn’t support copying row height. You have to copy row height manually or use the format painter.

Copy Row Height

Change Manually

Say you have an Excel worksheet that has the first row with a different (higher) size than other rows.

Now you want to copy the height of Row 1 to Row 2 and make them the same height.

1. Right-click the row heading (row number on the left side) whose height you want to copy (in this example Row 1), and choose Row Height…

2. In the pop-up window, you can see that row height is 36. You need to remember this value (or copy it) and click OK.

3. Now right-click the row heading where you want to paste the row height (Row 2), and choose Row Height…

4. In the pop-up window, type in (or paste) the row height from Row 1, and press OK.

The row height is copied from Row 1 to Row 2, and now both rows have the same height (36).

See also

• VBA Set Row Height
• Resize to Default Row Height
• Resize Multiple Rows or Columns at Once

Use the Format Painter

Another option to copy row height is to use the format painter.

1. Click the row heading (row number) to select the row whose height you want to copy (here, Row 1). Then in the Ribbon, go to Home > Format Painter.

2. Now just click on the row heading of a row where you want to paste the height. As a result, both rows now have the same height.

Tip: Using Format Painter copies all properties of Row 1 (including colors, fonts, borders, etc.). So if you want to copy only the height of a row, you should use Format Painter before applying any other changes to the original row.

Copy Row Height in Google Sheets

You can also copy row height manually in Google Sheets.

1. Right-click the row heading whose height you want to copy (here, Row 1), and choose Resize row.

2. In the pop-up window, you can see that row height is 36. You need to remember this value or copy it and click OK.

3. Now, right-click the row heading where you want to paste the row height (Row 2), and choose Resize Row.

4. In the pop-up window, check Specify row height, type in (or copy) the row height from Row 1, and press OK.

Finally, row height is copied from Row 1 to Row 2 and now both rows have the same height (36).

You can use Paint format in Google Sheets the same way as Format Painter in Excel.