copy formatting?

Steven · Nov 25, 2006

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 · Nov 25, 2006

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

copy formatting?

Steven

Ron de Bruin