Auto filter drop down box

T

tim s

I have a workbook that I'm sharing on my computer network using excel 2003
and I have put an auto filter on one of the columns in a worksheet. The
problem is on some of the computers when you click on the drop down icon the
"sort acending" "sort decending" options do not appear. On those computers
I'm having the problem with the drop down box only has "all", "blanks", "non
blanks", and specific cell values. Does anybody know how to get "sort
acending" and "sort Decending" to appear in that drop down box?
 
D

Dave Peterson

These features were added in xl2003.

Maybe it's time to get your IT staff to upgrade everyone to a single version.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
filter not working 2
Filter not showing blanks option 6
Drop down lists 1
Filter (blanks) with two or more unique values not working 1
auto filter problems 2
Cannot See Sort Ascending/Descding option in drop down filter 1
Using a drop-down box to sort data based on seperate columns 2

Top