You can paste the column width, but it is a separate task.
Paste Special -> Column Widths
I don't know how to do it for heights.
Scott
> Can I copy and paste data in a way that the column width/row height is also
> copied? If so, how?
[quoted text clipped - 5 lines]
> "Those who hammer their guns into plows will plow for those who
> do not!" --Thomas Jefferson
Gord Dibben - 29 Nov 2006 17:10 GMT
For row heights, if you select the entire row the height will paste.
Individual cells.........no.
Gord Dibben MS Excel MVP
>You can paste the column width, but it is a separate task.
>
[quoted text clipped - 13 lines]
>> "Those who hammer their guns into plows will plow for those who
>> do not!" --Thomas Jefferson