software

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

I don't think so.

JosiePosie21 wrote:
gt;
gt; I am using Autofilter in a spreadsheet and it automatically includes quot;Top 10quot;
gt; as well as quot;Blanksquot; and quot;Non Blanksquot; in the drop down menus of each category.
gt; Is there a way to remove these?

--

Dave Peterson

I agree with Dave.

However, you only get quot;Blanksquot; and quot;Non Blanksquot; 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