Auto Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been having problems with Auto Sort in Excel 2000.
I want to sort data by the Country then by the Month, but
when I use Auto Sort, it only sorts it by Country and not
by Month aswell, I use Data, Sort Option to do this.
 
If you click the Sort Ascending or Sort Descending button on the
toolbar, the table will be sorted by the column that contains the active
cell.

You could select one cell in the month column, and click Sort Ascending.
Then select one cell in the Country column, and click the Sort Ascending
button.

Or, select the entire table, and use Data>Sort, as you have been doing.
 
Back
Top