Copy Row Heights

September 26, 2023 - by Bill Jelen

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) — Figure 1333. Find or adjust one row height.

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. — Figure 1334. Choose entire rows, then click the Format Painter.

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. — Figure 1335. Select as many rows as in the copied section.

This article is an excerpt from Power Excel With MrExcel

Title photo by Daryan Shamkhali on Unsplash