How do I get rid of "Top 10" and "Custom" choices Autofilter?
 

I am using Autofilter in a spreadsheet and it automatically includes "Top 10"
as well as "Blanks" and "Non Blanks" in the drop down menus of each category.
Is there a way to remove these?

How do I get rid of "Top 10" and "Custom" choices Autofilter?
 

I don't think so.

JosiePosie21 wrote:

I am using Autofilter in a spreadsheet and it automatically includes "Top 10"
as well as "Blanks" and "Non Blanks" in the drop down menus of each category.
Is there a way to remove these?

--

Dave Peterson

How do I get rid of "Top 10" and "Custom" choices Autofilter?
 

I agree with Dave.

However, you only get "Blanks" and "Non Blanks" listed at the bottom of
the values in the pull-down if you have any blanks in the range covered
by the filter, so if you can avoid having any blanks (as these often
appear at the bottom of your data), then at least you could get rid of
these two messages.

Hope this helps.

Pete