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?

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

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