Thread: AutoFilter - get rid of default choice
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote