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:
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:
- Select any row whose row height you want to copy by left-clicking on the row number as shown below.
- Click on the Home tab in the ribbon.
- Then click on the Format option
- In the options that show up, then click on the Row Height option.
- 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.
- 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.
- 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).
- 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)
- 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.
Similarly, the Row Height option is also available by right-clicking on the row number as shown below.
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.
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.
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:
- 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.
- Now click on the Home tab in the ribbon.
- Then click on the Format Painter option.
- This will highlight the selected row with a dotted outline as shown.
- Now select the row where you want to apply that formatting. In this example, I am going to choose the last row (row 11).
- 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.
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.
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:
- Left-click on the row number to select it. This will also highlight the entire row (as shown below).
- 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)
- 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.
- Now right-click anywhere on the highlighted area and then choose the ‘Paste Special’ option.
- 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.
- In doing so format (Row Height) of row 1 is applied to row 11 as shown
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.
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
- 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
- Download and install the Add-in.
- After installation, it appears in the Ribbon as shown below:
Below I have a dataset where the last three rows have some uneven row height compared to other rows.
We want all the row heights to be the same.
So let’s do it using quickly using Kutools:
- 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
- Click on the Kutools tab. This would only become available when you download the add-in and then enable it.
- Click on the Copy Range
- 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.
- When you hit Ok a pop-up window will appear that asks for the destination cells where to paste the format.
- 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.
- Click Ok
- This will paste the row height in all three rows. The result can be seen in the below screenshot.
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
- Quickly Select the row whose Row Height you wanna change by pressing shift + spacebar. This will select the entire active row.
- Press one after another following keys ALT + H + O + H.
- A pop-up window appears from where you can change the Row Height.
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:
- How to Select Every Other Cell in Excel
- How to Select Alternate Columns in Excel (or every Nth Column)
- How to Delete Hidden Rows or Columns in Excel?
- How to Move Row To Another Sheet Based On Cell Value in Excel?
- How to Hide Rows based on Cell Value in Excel
- How To Set Column Width in Inches (or Centimeters) in Excel?
- How to Print Row Numbers in Excel
- How to Select Multiple Rows in Excel
- Copy and Paste in Excel (Keyboard Shortcut)
- Row vs Column in Excel – What’s the Difference?
- Autofit Column Width in Excel (Shortcut)
- Excel Autofit Row Height Not Working