Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() "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 | |
|
|
![]() |
||||
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 |