Go Premium for a chance to win a PS4. Enter to Win

x
?
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,355 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
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. …

783 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