AutoFilter Question

Is there a way to remove the automatically displayed filter options?
In other words:

I have a spreadsheet with Apples, Bananas, and Cherries.

I want to filter by the particular fruit, but I dont want to see Top
10, Blank, Non-Blank, Custom, etc. I just want to see Apples,
Bananas, or Cherries.

TIA

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Roger
Sat Dec 31 02:59:28 CST 2005

Hi

I don't think this is possible, but someone might come up with a VBA
solution to achieve this.
Instead, why not use Advanced Filter, and have data validation set up in the
cell where the user selects the fruit, to just show the desired values.

Take a look at Debra Dalgleish's site to see example of how to use Advanced
Filter and Data Validation
http://www.contextures.com/xladvfilter01.htm

http://www.contextures.com/xlDataVal01.html


--
Regards

Roger Govier


"Norg Bort _machine@hot mail. com>" <norgbort<removeremoveremove> wrote in
message news:thacr19rf4757122kc4i0gldn8f8i476as@4ax.com...
> Is there a way to remove the automatically displayed filter options?
> In other words:
>
> I have a spreadsheet with Apples, Bananas, and Cherries.
>
> I want to filter by the particular fruit, but I dont want to see Top
> 10, Blank, Non-Blank, Custom, etc. I just want to see Apples,
> Bananas, or Cherries.
>
> TIA
>
> ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
> News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
> Newsgroups
> ----= East and West-Coast Server Farms - Total Privacy via Encryption
> =----

Norg
Wed Jan 04 02:02:31 CST 2006

Just got back from vacation...

I already have validation for my "fruit" data, but Im not sure how to
really use the Advanced filter for what I want to do. I just want a
quick way to see, in an ever growing/changing list exactly which
Apples are doing what... without any of the Orange data cluttering up
the works. (Or, vice versa).

Anyway, I will hunt around that site you pointed me towards...

Thanks for the assistance.

On Sat, 31 Dec 2005 08:59:28 -0000, "Roger Govier"
<roger@technologyNOSPAM4u.co.uk> wrote:

>Hi
>
>I don't think this is possible, but someone might come up with a VBA
>solution to achieve this.
>Instead, why not use Advanced Filter, and have data validation set up in the
>cell where the user selects the fruit, to just show the desired values.
>
>Take a look at Debra Dalgleish's site to see example of how to use Advanced
>Filter and Data Validation
>http://www.contextures.com/xladvfilter01.htm
>
>http://www.contextures.com/xlDataVal01.html

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----