Excel 2003

[Guest]

Hello
just wanted to ask if it is possible to change the default setting of the
autofilter->customized filter from "equals" to "contains" by default for all
past and future worksheets
tried a bit with recording macros and stuff but dind't really find a solution
best regards

Stormy

 

[Dave Peterson]

I couldn't find a way.

So what I use is Equals, but then type in
*Stormy*

The asterisks are wild cards and it's the same as contains Stormy.

I also use:

*Stormy (ends with)
Stormy* (begins with)