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

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

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



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

[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
"jmeg" <jmeg@discussions.microsoft.com> wrote in message
news:DA4341DC-E93B-4482-81B5-11323C05636E@microsoft.com...
> 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.