AutoFilter does not include ascending or descending options

[ronjon444]

Excel 2002 - When I turn on auto filter in a spreasheet and attempt to filter
there is no ascending or descending options in the menu. I do get all names
/ numbers top 10, blanks, but no option for ascending or descending.

Thanks for the help.

 

[Conan Kelly]

ronjon444,

If I'm not mistaken, that functionality was added in XL 2003. That is why
you are not seeing it in XL2002

HTH,

Conan

 

[reitanospa1]

If I'm not mistaken, you can sort either way after filtering without
losing the filter.

 

[Gord Dibben]

Conan

You are not mistaken.


Gord Dibben MS Excel MVP

 

[djmunoz]

If I'm not mistaken, you can sort either way after filtering without
losing the filter.

Once you set auto filters on header rows, click on cell with pulldown
handle to make cell active. Then, do a ALT+UP ARROW and you will see
the option for Ascending and Decending. I also discovered that
sometimes you just have to move the scrollbar on the pulldown field up
and they are there. For some reason Excel doesn't show these each time
by default.

Hope this helps!

 

[Dave Peterson]

You sure those options exist in xl2002?

I think that this sorting stuff was added in xl2003.