Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoFilter - get rid of default choice
Hi,
I have my auto-filter on on many columns. I want to get rid of default choice for filter (i.e. Top 10, Blanks, NonBlanks)...I simply want it to list my values (lower, higher, etc.) although I would obviously like to keep "All" to reset back to non-filter mode. At the very least, I want to get rid of (Top 10), this totally doesn't make any sense for my data and confuses users. Thank you for your help. S |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AutoFilter - get rid of default choice
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter to last week by default | Excel Discussion (Misc queries) | |||
Choice of Formula | Excel Worksheet Functions | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
how do I include a "do nothing choice" in an IF | Excel Worksheet Functions | |||
Is IF the best choice | Excel Worksheet Functions |