See all How-To Articles

How to Copy Row Height in Excel & Google Sheets

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

 

copy row height initial

 

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 using the format painter.

Copy Row Height

Change Manually

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

 

copy row height initial

 

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…

 

copy row height manually 1

 

  1. 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.

 

copy row height manually 2

 

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

 

copy row height manually 3

 

  1. In the pop-up window, enter (or copy) the row height from Row 1, and press OK.

 

copy row height manually 4

 

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

 

copy row height manually final

 

See also:

Use the Format Painter

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

  1. Select the row whose height you want to copy (here, Row 1), by clicking on the row heading (row number). After that, in the Ribbon, go to Home > Format Painter.

 

copy row height format painter 1

 

  1. 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.

 

copy row height format painter 2

 

Note: 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 changes to the row which height is being copied.

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 (in this example, Row 1), and choose Resize row.

 

google sheets copy row height manually 1

 

  1. 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.

 

google sheets copy row height manually 2

 

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

 

google sheets copy row height manually 3

 

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

 

google sheets copy row height manually 4

 

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

 

google sheets copy row height manually final

 

You can also use the Format Painter in Google Sheets exactly the same as in Excel.