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

J

jmeg

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.
 
D

Dave Peterson

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.
 
G

Gilles Desjardins

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
 
Top