distributed alignment

[jerry12302]

I copied data from a Lotus spreadsheet into excel. I'm having horizontal alignment problems.

I want to align the contents of a cell so it is evenly spaced across 4 cells, in Lotus this is the "align across columns" option.

I tried highlighting the 4 cells involved and choosing the "distributed" option, but it doesn't work.

Any ideas?

 

[dcardno]

The data must be in the left-most cell of the range: select the whole range and right click on Format | Cells | Alignment and then in the "Horizontal" dropdown select "Center Across Selection"

There is an icon on the standard (? - I always customize mine, so it might be on "format" or something) toolbar that almost does this but it also merges the cell. Merged cells are evil because they interfere with Cut / Paste operations; I have assigned that icon to run the following Macro in my Personal.xls file...

Sub CenterAccrosColumns()

With Selection
    .HorizontalAlignment = xlCenterAcrossSelection
    .WrapText = False
    .MergeCells = False
End With
End Sub

 

[jerry12302]

Thanks for the reply, but I don't want the contents centered across the selection, I want it to fill up the space entirely left to right.

Example, from this...

|column A|column B|column C|column D|
Text to fill across columns

to this...

|column A|column B|column C|column D|
T e x t t o f i l l a c r o s s c o l u m n s

This is simple in Lotus, I use it all the time, but there doesn't seem to be a way to do this in Excel 2003.