Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filter drop down box
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filter drop down box
These features were added in xl2003.
Maybe it's time to get your IT staff to upgrade everyone to a single version. tim s wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO values in Auto-filter drop-down | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down list to run Auto filter on another sheet | Excel Discussion (Misc queries) | |||
Excel Auto Filter will not show all items in the drop down - why? | Excel Discussion (Misc queries) | |||
Why do I not see all my data when I use the auto filter drop down | Excel Discussion (Misc queries) |