When I want to copy column width, I simply select a cell or cells in
the original column(s), right-click Copy, select a target cell, and
right-click Paste Special - Column Width.

Is there a similar set of steps to copy Row Height?

The only way I can see is: select a cell in the row, click Format -
Row - Height and make note of the height, select a cell in the target
row, click Format - Row - Height, and enter the height of the
original row.

That's a bummer, especially when I have a range of rows with dissimilar
heights that I want to copy.

I do not want to write a VBA macro for this purpose.

Use Format Painter.
Select row, set row height using format menu, dbl clk Format Painter, select
row(s) to apply height.

" wrote:

When I want to copy column width, I simply select a cell or cells in
the original column(s), right-click Copy, select a target cell, and
right-click Paste Special - Column Width.

Is there a similar set of steps to copy Row Height?

The only way I can see is: select a cell in the row, click Format -
Row - Height and make note of the height, select a cell in the target
row, click Format - Row - Height, and enter the height of the
original row.

That's a bummer, especially when I have a range of rows with dissimilar
heights that I want to copy.

I do not want to write a VBA macro for this purpose.

You can do the two-step dance.

1. Select the rows and Copy then Paste SpecialFormats

2. If any cells to copy, select them and Paste.


Gord Dibben MS Excel MVP

On 21 Jan 2007 13:15:03 -0800, wrote:

When I want to copy column width, I simply select a cell or cells in
the original column(s), right-click Copy, select a target cell, and
right-click Paste Special - Column Width.

Is there a similar set of steps to copy Row Height?

The only way I can see is: select a cell in the row, click Format -
Row - Height and make note of the height, select a cell in the target
row, click Format - Row - Height, and enter the height of the
original row.

That's a bummer, especially when I have a range of rows with dissimilar
heights that I want to copy.

I do not want to write a VBA macro for this purpose.

Reb wrote:
Use Format Painter.
Select row, set row height using format menu, dbl clk Format Painter, select
row(s) to apply height.

That did not copy row height, whether I single-click or double-click
FP. Perhaps I should mention that I am using Office Excel 2003
(11.5612.5606).

But FP did copy other format specifications (e.g. Percentage with 2
Decimal Places). I do __not__ that. I simply want to copy row height,
just as I can __just__ copy column width.

Gord Dibben wrote:
You can do the two-step dance.
1. Select the rows and Copy then Paste SpecialFormats
2. If any cells to copy, select them and Paste.

While that does copy row height, it also copies other cell format
specifications (e.g. Percentage with 2 Decimal Places). I only want to
row height, just I can __just__ copy column width. I should mention
that I am using Office Excel 2003 (11.5612.5606).

Errata....

I wrote:
Reb wrote:
Use Format Painter.
Select row, set row height using format menu, dbl clk Format Painter, select
row(s) to apply height.

That did not copy row height, whether I single-click or double-click
FP.

My bad! I selected a cell, not the entire row. Nonetheless, FP does
copy other format specifications. As I noted previously, I do not want
that. I simply want to copy row height, just as I can copy only column
width.

nomail

Your original post stated an injunction against VBA so I think you are out of
luck.


Gord

On 21 Jan 2007 16:45:48 -0800, wrote:

Gord Dibben wrote:
You can do the two-step dance.
1. Select the rows and Copy then Paste SpecialFormats
2. If any cells to copy, select them and Paste.

While that does copy row height, it also copies other cell format
specifications (e.g. Percentage with 2 Decimal Places). I only want to
row height, just I can __just__ copy column width. I should mention
that I am using Office Excel 2003 (11.5612.5606).

This might work for you:

Select the row(s), either contiguous or non-contiguous, that you want to
change.
Place cursor on the bottom edge of one of the selected row headers, hold
down the mouse btn and drag to the height you want (indicated on the pop up)
and release the mouse btn. Selected row(s) should be at the indicated height.

" wrote:

Errata....

I wrote:
Reb wrote:
Use Format Painter.
Select row, set row height using format menu, dbl clk Format Painter, select
row(s) to apply height.

That did not copy row height, whether I single-click or double-click
FP.

My bad! I selected a cell, not the entire row. Nonetheless, FP does
copy other format specifications. As I noted previously, I do not want
that. I simply want to copy row height, just as I can copy only column
width.

Gord Dibben wrote:
Your original post stated an injunction against VBA so I think you are out of
luck.

That's what I suspected. Thanks for the confirmation. Seems like an
odd oversight, even if MS thinks it would be used less often. Oh
well....

Reb wrote:
This might work for you:
[....]
Place cursor on the bottom edge of one of the selected row headers, hold
down the mouse btn and drag to the height you want

Thanks. Certainly easier than having to enter the row height using
Format - Row - Height, and apparently the best we can do. But not as
straight-forward as Paste Special - Column Width. Thanks again.