I have a list with name, company, address, city.....etc. When I click on
data sort (i do check the box to include column headings) and do a sort by
say address, it will sometimes exclude a column such as name from the sort.
It does not always do this. Is this a glitch? Do I need to highlight the
entire list before I sort?

Also, sometimes if I just use the Ascending or Descending icon rather that
going to data, sort it will only sort that column and not the rest of the
data with it.

Those are the reasons that I don't trust excel to guess at the range I want
sorted.

I'll either select the range, then use Data|Sort

(or use a macro that defines the range to sort.)

Tracy wrote:

I have a list with name, company, address, city.....etc. When I click on
data sort (i do check the box to include column headings) and do a sort by
say address, it will sometimes exclude a column such as name from the sort.
It does not always do this. Is this a glitch? Do I need to highlight the
entire list before I sort?

Also, sometimes if I just use the Ascending or Descending icon rather that
going to data, sort it will only sort that column and not the rest of the
data with it.

--

Dave Peterson