If you copy a range you can use paste specialcolumn widths. There is no row
height option.


--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"Gord Dibben" wrote:

Mixed message in your description.

"copy a sheet" and "copy a range" are not the same thing.

If copying a sheet using right-clickmove or copycreate a copy the
formatting will not change.

If you copy entire rows and columns the heights and widths will be copied.

If you simply copy a range of cells, the heights and widths will not copy.


Gord Dibben MS Excel MVP



On Thu, 29 Oct 2009 21:04:23 -0400, "Dorian C. Chalom"
wrote:

When I copy a sheet the row hieghts do not copy over as well.
How can I make the Row hieghts and for that matter column widths copy over
when I copy a range of a spreadsheet?

Thank you...


.