copy formatting?

[Steven]

Is there a way to copy and paste from a formatted set of cells, to an
unformatted set and have the formatting copy/paste as well, so that
column/row sizes adjust to be the same?

Thanks

Steven Shelton

"Those who hammer their guns into plows will plow for those who
do not!" --Thomas Jefferson

 

[Ron de Bruin]

Hi Steven

With pastespecial you can also copy column width but not row height
See the edit menu for PasteSpecial

If you only want to copy a range to another place to view/print then you can try this
Row and column width is working then
http://www.rondebruin.nl/print.htm#non-contiguous