how do I copy multiple column widths from a worksheet in one work.
 

how do I copy multiple column widths from a worksheet in one workbook to one
in another workbook?

how do I copy multiple column widths from a worksheet in one work.
 

Hi Lockport

Ctrl A to select all cells or select a few columns
Ctrl c to copy

Go to the other workbook
Edit Paste Special in the menu bar
Choose columnwidth

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Lockport" wrote in message ...
how do I copy multiple column widths from a worksheet in one workbook to one
in another workbook?

how do I copy multiple column widths from a worksheet in one work.
 

Say the formats you want are in column ABC. Highlight ABC in the
workbook. Hit copy. Go to the oher work book highlight ABC hit paste
special. Then click format.


--
Gbonda
------------------------------------------------------------------------
Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758
View this thread: http://www.excelforum.com/showthread...hreadid=567620