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

AutoFilter - get rid of default choice
 

I don't think you can change this behavior.

wrote:

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

--

Dave Peterson