Solved

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

Posted on 2011-09-09
2
1,039 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now