You are limited to 2 criteria with Auto Filter, but you can use wild cards in
the criteria and/or change it from "equal to" to several other things. You
can also filter multiple columns (the criteria for all columns is ANDed). If
you're really stuck, Advanced Filter might give you what you need. But it's
not flexible like the auto filter, and you need to be careful to copy the
filter results to a different location or you'll lose data.

"sbrimley" wrote:

Is it possible to select more than 2 options using custom auto filter?

I have a worksheet filled with contact names and the cities in which they
live and would like the filter results to show 3 or 4 cities at a time. Is
this possible? I have been playing with custom auto filter and so far I am
only able to view two cities at a time. Any suggestions?
Thanks