Excel 2003
 

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

Excel 2003
 

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)



Stormy wrote:

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