Autofilter Options

Is there a way to remove some of the options when using Autofilter?

If possible, I do not wish to see the (Top 10 . . .), (Blanks), (Nonblanks),
etc. I would like to only see the (All) and (Custom).

Thanks!

In short...no, sorry

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Eaglered" <Eaglered@discussions.microsoft.com> wrote in message
news:AABF5FBC-DAAF-4CA1-BD35-B60CE1AACB36@microsoft.com...
> Is there a way to remove some of the options when using Autofilter?
>
> If possible, I do not wish to see the (Top 10 . . .), (Blanks),
> (Nonblanks),
> etc. I would like to only see the (All) and (Custom).
>
> Thanks!

That's what I figured but thought it was worth a shot.

Thanks!

"Nick Hodge" wrote:

> In short...no, sorry
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Eaglered" <Eaglered@discussions.microsoft.com> wrote in message
> news:AABF5FBC-DAAF-4CA1-BD35-B60CE1AACB36@microsoft.com...
> > Is there a way to remove some of the options when using Autofilter?
> >
> > If possible, I do not wish to see the (Top 10 . . .), (Blanks),
> > (Nonblanks),
> > etc. I would like to only see the (All) and (Custom).
> >
> > Thanks!
>
>
>