View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mariekek5 mariekek5 is offline
external usenet poster
 
Posts: 62
Default autofilter - custom...

Hi,

My autofilter (Excel 2003) gives me several options:
- all
- top 10
- custom
- x
- y
- z
- etc.

2 questions:

1) Is it possible with custom to select more than 2 things....now I can use
equals x or equals y ... but not equals x or y or z.

2) is it possible to create a custom that will stay in the options? Like if
I want the option to show x and y, do I need to customize that eveytime,...or
can I make an extra option in de drop down box with "x and y" automatically
in it?

Thanks in advance.

Regards,
Marieke