Copy Row Heights
September 26, 2023 - by Bill Jelen
![Copy Row Heights Copy Row Heights](/img/excel-tips/2023/09/copy-row-heights.jpg)
Problem: That last trick for pasting column widths works well. How do I do the same thing for row heights?
Strategy: As with column widths, you can quickly find the row height or adjust the row height using the border between row headers.
![Drag the horizontal bar between the "2" and "3" row labels. The tool tip says Height 35.25 (47 pixels)](/img/content/2023/09/LE10001226.jpg)
There is not a Paste Special option for row heights. You can use the Format Painter to copy row heights. However, the Format Painter will also copy cell colors, font sizes, borders, and so on.
To use the Format Painter, select entire rows. Say that you want to copy row heights in rows 1:10 to rows 21:30.
To copy the heights of rows 1:10, click and drag from the row 1 heading to the row 10 heading.
Click the Format Painter icon in Home tab. The mouse cursor changes to a paintbrush.
![Select a range and click the Format Painter icon.](/img/content/2023/09/LE10001227.jpg)
When you release the mouse, Excel will paste all formatting, including row heights from the original range.
Don’t click any cells while the format painter is active. The next action you have to take is selecting 10 rows. Be sure to click on the row header and not the cell. Click on 21 and drag to 30. The tooltip will confirm that you’ve selected 10 rows.
![With the cell pointer showing the paintbrush, select 10 entire rows. The tool tip should say 10R for 10 Rows.](/img/content/2023/09/LE10001229.jpg)
This article is an excerpt from Power Excel With MrExcel
Title photo by Daryan Shamkhali on Unsplash