N
nomail1983
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.
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.