I strongly advise against ever using those auto-sort toolbar buttons.

In fact, I have removed them from the machines of all my users at all my
locations, and have not received any more complaints of jumbled data due to
mis-sorting.
XL sorts correctly with those buttons most of the time, BUT ... *NOT* all of
the time, and one bad experience is more then enough.

Manually select the *entire* range that you wish to include in the sort and
then use,
<Data <Sort
And make sure that you specify whether or not you have a 'header' row, which
was your problem when you say that the first row wasn't included in the
sort.

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


"Jennifer" wrote in message
...
Hi. I have a spreadsheet that deals mostly with text. I have a column that
has different cities listed in each cell. When I select that column and hit
the A-Z sort button, it is not working, even after I select the expand the
sort selection. Or sometimes it will sort everything BUT the first item.
Anyone else have this problem?
Thanks!