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?

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.

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" <[email protected]> wrote in message news:[email protected]...
> how do I copy multiple column widths from a worksheet in one workbook to one
> in another workbook?