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

L

Lockport

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

Ron de Bruin

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
 
G

Gbonda

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