data sort is not including all columns in sort

[Guest]

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]

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