?
Solved

Excel 2010 - "Match entire cell contents" is always checked by default whenever I use the "Find" command.

Posted on 2011-09-09
2
Medium Priority
?
1,430 Views
Last Modified: 2012-05-12
Whenever I click on "Find" the "Match entire cell contents" box is ALWAYS checked.
I have to constantly uncheck it to effectively search for things.
Is there anyway to turn this off or change its default setting???
 Shot of problem.
0
Comment
Question by:rr4406pak
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 36510861
Do you have any addins or startup workbooks with code in them? The default should be unchecked.
0
 

Author Closing Comment

by:rr4406pak
ID: 36510903
Well what do you know!
I had an S-Plus add-in that was in there when I reviewed what add-ins I had running.
I turned it off and the check mark disappeared!
Thanks!
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question