Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I change the default for custom filters?
"Custom filte" always begins with "Show rows where <field name EQUALS ..."
I almost always use CONTAINS. Can I change the default so that it'll automatically display CONTAINS as the starting criterion? If so, how? I'm in Mac OS 10.4.7. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I change the default for custom filters?
You can't change it the wintel version.
But you can fool it. Say you want to check to see if the value contains cbry. Use Equals and *cbry* surround your value with asterisks to get the equivalent of Contains Leading asterisk (*cbry) is the same as ends with trailing asterisk (cbry*) is the same as begins with Why, oh, why isn't that dropdown box just a hair bigger! cbry wrote: "Custom filte" always begins with "Show rows where <field name EQUALS ..." I almost always use CONTAINS. Can I change the default so that it'll automatically display CONTAINS as the starting criterion? If so, how? I'm in Mac OS 10.4.7. Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can I change the default for custom filters?
"Dave Peterson" wrote: You can't change it the wintel version. But you can fool it... Use Equals and *cbry* surround your value with asterisks to get the equivalent of Contains YEEEAAAAHHH -- works fine! A muy cool workaround. Many thanks, Dave P! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the default cell format? | Excel Discussion (Misc queries) | |||
Change default height/width of up/down arrow, heading, bottom bar | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
change default chart settings for new excel charts automatically | Charts and Charting in Excel | |||
Change the default chart colours | Charts and Charting in Excel |