Distribute Columns Evenly

[Galen W. Sievert, PC, MS Ed.]

Hi,
How do I? This is available in Word/Tables.
Thank you

 

[Frank Kabel]

Hi
AFAIK this option is not available in Excel

 

[Galen W. Sievert, PC, MS Ed.]

Frank,
Drats! Will have to do it the old fashion way. : (

Thanks for your reply!

--
Galen W. Sievert

Hi
AFAIK this option is not available in Excel

 

[JE McGimpsey]

One way (using a macro):

Public Sub DistributeColumnsEvenly()
Dim dSum As Double
Dim rCell As Range
With Selection
For Each rCell In .Rows(1).Cells
Debug.Print dSum, rCell.ColumnWidth
dSum = dSum + rCell.ColumnWidth
Next rCell
.ColumnWidth = dSum / .Columns.Count
End With
End Sub


If you're unfamiliar with macros, see David McRitchie's "Getting Started
with Macros"

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Darlene Kupke]

Hi,
How do I? This is available in Word/Tables.
Thank you

HI

The nontechie way is to set up your preferences on a worksheet with your
choice of column, font, etc. Then just use it as a template.

bye

Darlene