Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the default cell format? Álvaro Excel Discussion (Misc queries) 5 February 27th 06 05:47 PM
Change default height/width of up/down arrow, heading, bottom bar jojo Excel Discussion (Misc queries) 1 November 13th 05 09:10 PM
How to change the default Border, Font Color, and Cell Color Elijah Excel Discussion (Misc queries) 3 November 2nd 05 11:52 PM
change default chart settings for new excel charts automatically Nedwardt Charts and Charting in Excel 0 October 20th 05 08:27 PM
Change the default chart colours TonyJD Charts and Charting in Excel 2 January 20th 05 01:06 AM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"