Paste Column Height?

[adste89]

Hello,

Does any know how you copy the column height to other cells? You can do a paste special on the column width but not the height :s

Adam

[:) Sixthsense :)]

In Paste Special there is a option button named COLUMN WIDTHS. Check it out…

[alexander.small]

Hello,

Does any know how you copy the column height to other cells? You can do a paste special on the column width but not the height :s

Adam

I don't think there is a way to do this, however you could use code:

Please Login or Register  to view this content.

this will make the height of row 2 the same as the height of row 1

Please Login or Register  to view this content.

this will do the same but for multiple rows

Hope this helps

[XOR LX]

Another way is to highlight the entire row whose height you wish to transfer, right-click/Row Height, press ENTER.

Now select all the rows to which you wish to apply this row height and press F4.

Regards