AutoFilter - get rid of default choice

S

sargum

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
 
D

Dave Peterson

I don't think you can change this behavior.

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
Click to expand...
 

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

Utilizng full AutoFilter features while specific cells are protect 0
Merged cells disturb autofilter indicator 2
Utilizng full AutoFilter features while specific cells are protect 0
Autofilter problem 9
Custom Autofilter defaults 1
Autofilter Query 0
How do I get rid of "Top 10" and "Custom" choices Autofilter? 2
Difficulty "countif"-ing number of "L1" or "L2" on an autofiltered 4

Top