how do I copy multiple column widths from a worksheet in one workbook to one in another workbook?
L Lockport Aug 2, 2006 #1 how do I copy multiple column widths from a worksheet in one workbook to one in another workbook?
R Ron de Bruin Aug 2, 2006 #2 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
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 Aug 2, 2006 #3 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
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