Maybe you should forget about the Autofilter.

Select all the columns then DataSort and sort on column A.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 12:15:02 -0700, soteman
wrote:

Maybe I was confused on the function itself. When I hit the arrow for the
drop down menu it looks like this.

Sort Ascending
Sort Descending
------------------
(All)
(Top 10)
(Custom)
1
2
3
4
5
etc.

Those are the sort functions that I am trying to get to work. I have used
this sort function on this list in other files and have had it work. But for
some reason it is not working in this one.