View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] sargum@umich.edu is offline
external usenet poster
 
Posts: 19
Default 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