Column Width

P

phil2006

I have 10 sheets in my workbook and want to size the column widths o
every sheet to match those in on the first sheet. Is this possible
 
C

CLR

Practice first on a copy of your file..............Select the columns on
Sheet1, then click on the FormatPainter paintbrush icon, then left-click on
one of the other sheet tabs and hold down ctrl and select all the rest of
those you wish converted, then highlight those same columns you did on sheet
1 and release the mouse button.........

hth
Vaya con Dios,
Chuck, CABGx3
 
D

David Biddulph

phil2006 said:
I have 10 sheets in my workbook and want to size the column widths on
every sheet to match those in on the first sheet. Is this possible?
Click to expand...

If you go to the first sheet, select all the sheets, select a column, then
Format/ Column/ Width, & OK it, that setting will be transferred to the
other sheets. If you've got different widths for different columns you'll
probably have to do it separately for each width.
 
Top