How to Copy Row Height in Excel

We often came across a situation where we want to copy the row height from one row and apply the same to other rows. 

It would be quite tedious to manually adjust the row height for multiple rows. Also, manually changing the row height may not give you accurate results.

In this article, I am going to show some easy and quick ways to copy the Row Height and paste it to the destination cells in Excel.

Method 1: Copy Row Height Using the ‘Row Height’ Option in the Ribbon 

Let’s say we have some samples data of sales done by various Representative in different regions as shown below:

Dataset with uneven row height

Here all the rows have the same row height except the last one.

Below are the steps to copy the row height from the above rows and apply it to row 11:

  1. Select any row whose row height you want to copy by left-clicking on the row number as shown below.
Select the row from which to copy row height
  1. Click on the Home tab in the ribbon.
Click the Home tab
  1. Then click on the Format option
Click the Format option
  1.  In the options that show up, then click on the Row Height option.
Click on Row height
  1. A pop-up window will appear from which you can copy the Row Height. So copy this by selecting the value and pressing CTRL + C from the keyboard.
Copy the row height value
  1. Now select the row for which you want to change the Row Height by selecting the row number as described in Step 1.  In this example, I am going to select row 11 as I want to change its row height.
Select the row to which you want to copy the row height
  1. Click the Home tab, then click on the Format icon. In the options that show, click on Row Height. A pop-up window will appear showing the row height value of the selected row (which is row 11 in this example).
Row height dialog box
  1. Replace the value with the Row Height of the copied value which is 40.8 by pressing CRTL + V (or you can manually enter the value)
  2. Below is the screenshot of the resulting data where the Row Height of row 11 has been changed and it now has the same Row Height as all the other rows.
Data where row height has been copied

Similarly, the Row Height option is also available by right-clicking on the row number as shown below. 

Right-click and then select row height

While this method works best if you want to quickly copy the Row Height for a couple of rows, in case you have a large data set, this method may be long and tedious.

In such cases, you can use the next method that I’m going to cover – using Format Painter.

Also read: How to Copy and Paste in Excel Without Changing the Format?

Method 2: Copy Row Height using Format Painter

This is quite an efficient approach for copying row height in Excel. Format Painter is a tool that let you copy formatting from one object to another. You can also use this for copying the row height as well. 

Let’s do it with an example, I am going to use the same sales data set described in Method 1.

Dataset with uneven row heights

Now I will show you how you can change the Row Height of the last row using Format Painter.

Below are the steps to copy the row height from the rows above and apply it to row 11:

  1. Select the row whose format (Row Height) you want to copy by clicking on the row number. This will highlight the corresponding row as shown.
Select the row
  1. Now click on the Home tab in the ribbon.
Click the Home tab
  1. Then click on the Format Painter option.
Click on Format Painter
  1. This will highlight the selected row with a dotted outline as shown.
Copied cell get highlighted
  1. Now select the row where you want to apply that formatting. In this example, I am going to choose the last row (row 11).
Select the destination cell
  1. In doing so, the Format painter automatically pastes the copied format to the selected rows and adjusts the Row Height. The result is shown in the below screenshot.
Data where row height has been copied

Note: Format painter would not only copy Row Height but also any other formatting that there is in the row from which the formatting has been copied. Similar results could be achieved by using the Paste Special option which is expressed in the next section.

Also read: How to Copy Column Widths in Excel?

Method 3: Copy and Paste Row Height Using Paste Special 

Paste Special is a very useful feature in Excel that assist you in pasting content more flexibly.

Moreover, by using this feature you can copy and paste the format and row height of the cell. 

Below I have a dataset where I have uneven row heights.

Dataset with uneven row heights

As you can see from the above screenshot that all the rows have the same row height except the last one. 

Now what we want is to change the row height of the last row using the Paste Special option.

Below are the steps to do this:

  1. Left-click on the row number to select it. This will also highlight the entire row (as shown below).
Select the row to copy
  1. Now, right-click anywhere on the highlighted area and click on the Copy option. This will copy the entire row (including the row content, format, as well as its height)
Right-click and then select on copy
  1. Now select the row whose row height you want to change i.e row 11 in this example. This will select the entire row as shown below.
Select the row to paste the row height
  1. Now right-click anywhere on the highlighted area and then choose the ‘Paste Special’ option.
Select on Paste Special
  1. This will open a dialog box where we have various Paste Special otions. As we want to paste the row height, select the ‘Formats’ option and click Ok.
Select the Formats option
  1. In doing so format (Row Height) of row 1 is applied to row 11 as shown
Row height copied

Again, remember that this method will not only copy the row height but also the formatting from the copied cells. In this example, since we have the same formatting in the copied cell as well as the destination cell, it didn’t matter.

Also read: How to Make all Cells the Same Size in Excel (AutoFit Rows/Columns)

Method 4: Copying Row Height with Kutools Add-in

In the above sections, we have discussed various in-built options available in Excel to copy the row height.

Each one of them has its own advantage but none of the methods is as efficient as Kutools.

Kutools is a handy Excel Add-in that incorporates more than 300+ features. It assists you in performing complex tasks swiftly and easily.

In addition, using Kutools you can also copy the row height effortlessly. It is highly recommended to use Kutools for formatting row heights.

How to Download and Install Kutools

  1. Kutools is not a built-in feature in Excel. It is a third-party Excel Add-in that you have to manually install on your computer. Here is the link from where you can download this Add-in free of cost Kutools
  2. Download and install the Add-in.
  3. After installation, it appears in the Ribbon as shown below:
Click on Kutools option

Below I have a dataset where the last three rows have some uneven row height compared to other rows.

Last three rows have some uneven row height

We want all the row heights to be the same.

So let’s do it using quickly using Kutools:

  1. Select the row range of a similar number of rows whose Row Height you want to change. For instance, in this example, we have to change the Row Height of the last 3 rows so we must copy the row height of these three rows. To do this, I am selecting rows 2-4
Select the rows to copy
  1. Click on the Kutools tab. This would only become available when you download the add-in and then enable it.
Click on Kutools tab
  1. Click on the Copy Range
Click on Copy Ranges
  1. This will open a dialog box. Since we only want to paste the format (including the row height), select the Formats option and also check the ‘Including row height’ checkbox and hit Ok.
Select include row height
  1. When you hit Ok a pop-up window will appear that asks for the destination cells where to paste the format.
Copy Multiple ranges dialog box
  1. Select the first cell where you want to paste the format. As we have to change the Row Height of the last 3 rows so I am selecting the first cell in row 9.
Select the destination cell
  1. Click Ok
Copy Multiple ranges dialog box kutools
  1. This will paste the row height in all three rows. The result can be seen in the below screenshot.
Row height copied to three rows
Also read: Get Text to Fit in Cell in Excel

Method 5: Keyboard shortcut to Copy Row Height

If you quickly want to change the Row Height of any row using keyboard shortcuts you can do so

  1. Quickly Select the row whose Row Height you wanna change by pressing shift + spacebar. This will select the entire active row.
Select the entire row
  1. Press one after another following keys ALT + H + O + H.
  2. A pop-up window appears from where you can change the Row Height.
Copy the row height value

If you want to copy the row height from one row to another, you can first use the above keyboard shortcut to first copy the row height and then go to the cell where you want to paste the row height and use this keyboard shortcut again.

Above are all the techniques that can be used in order to copy the row height in Excel.

Each of the techniques has some advantages depending on the nature of the task you are working on.

If you’re comfortable using keyboard shortcuts, I would suggest using the shortcut as I find it to be quick and easy. And in case you want to copy the row height as well as the formatting, you can use the Format Painter or the Kutools method.

Other Excel articles you may also like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment