setup wrksht w/ column widths of 10 then 2 then 10 then 2 etc
 

Is there an easy way to set column widths...or do I have to change each
column separately? Want a worksheet with Col A = 10, Col B = 2, Col C = 10,
Col D = 2, etc.

setup wrksht w/ column widths of 10 then 2 then 10 then 2 etc
 

Select column A, then control-click on B, C, ...
Adjust the columnwidth to 10

Then select column B, ctrl-click on D, ...
and adjust the columnwidth to 2.



jmeg wrote:

Is there an easy way to set column widths...or do I have to change each
column separately? Want a worksheet with Col A = 10, Col B = 2, Col C = 10,
Col D = 2, etc.

--

Dave Peterson

setup wrksht w/ column widths of 10 then 2 then 10 then 2 etc
 

Set column A to 10, then column B to 2. Then drag mouse over A & B Right
mouse Copy, Then highlight all other columns you wish to modify, Right mouse
Click, Paste Special, Column widht. VOILA!

HTH
Gilles
"jmeg" wrote in message
...
Is there an easy way to set column widths...or do I have to change each
column separately? Want a worksheet with Col A = 10, Col B = 2, Col C =
10,
Col D = 2, etc.