Sorting Colums into alphabetical order

[tox]

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]

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

 

[JulieD]

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