Column Width
 

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?


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=559919

Column Width
 

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



"phil2006" wrote:


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?


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=559919

Column Width
 

"phil2006" wrote in
message ...

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?

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.
--
David Biddulph