Sorting Colums into alphabetical order

I'm trying to sort 50 columns into alphabetical order. The first column
contains a name and each column has a formula, How do I arrange the columns
into order and make sure all the info in the columns moves with the names?

TIA
tox

Save first--just in case this doesn't work!

If you select your range (last row of headers plus all the rows of details) and
all the columns in the range you want sorted, then excel should handle it
nicely.

Sometimes you can get lucky and excel will guess the correct range to sort.
I've always felt better by selecting my range first and not letting excel guess
(right or wrong).


tox wrote:
>
> I'm trying to sort 50 columns into alphabetical order. The first column
> contains a name and each column has a formula, How do I arrange the columns
> into order and make sure all the info in the columns moves with the names?
>
> TIA
> tox

--

Dave Peterson

Do not choose a range and then press the ascending or descending sort button. It will only sort the range not the table.

To sort,click on one cell in the column you want to sort. This is your key field. Now pressing the ascening sort button will sort the entire table and keep the names with the data.

One caution. There can be no spaces in your table in either columns or rows or excel will ignore data beyond the space when it sorts.

in addition, use Data / Sort to sort once you've selected your range, not
the toolbar icons (BTW i only select 1 cell in my ranges rather than the
whole range and i've never had a problem ... my ranges in this case are
defined by a blank column & a blank row)

Cheers
JulieD

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:421A6334.FCA81801@netscapeXSPAM.com...
> Save first--just in case this doesn't work!
>
> If you select your range (last row of headers plus all the rows of
> details) and
> all the columns in the range you want sorted, then excel should handle it
> nicely.
>
> Sometimes you can get lucky and excel will guess the correct range to
> sort.
> I've always felt better by selecting my range first and not letting excel
> guess
> (right or wrong).
>
>
> tox wrote:
>>
>> I'm trying to sort 50 columns into alphabetical order. The first column
>> contains a name and each column has a formula, How do I arrange the
>> columns
>> into order and make sure all the info in the columns moves with the
>> names?
>>
>> TIA
>> tox
>
> --
>
> Dave Peterson