Find - Entire Cells only

  • Thread starter Thread starter Andibevan
  • Start date Start date
A

Andibevan

Hi All,

Whenever I search for something (CTRL+F) in excel it always defaults to the
"Find entire cells only" setting.

Is there any way I can change this default setting - I want it to search for
any cell , not whole cells, by default.

Thanks

Andi
 
I use xl2003 and when I first open excel (with a blank workbook), I hit ctrl-f,
then that option is not checked.

But excel likes to help. It remembers the previous settings that you
used--including any VBA code that you may have run.

Are you sure that it's the default and not the result of a previous find?
 
I think you are right - it may also have something to do with whether you
save the document as well.

Thanks

Andi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can only delete an entire row not a cell in excel 2013? 1
Folder search 7
How can you select visible cells only by default, without Ctrl+G. 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Set default cell format while retaining overrides 3
How to give find function ( same as of ctrl F) in formula bar 3
Searching for... 2
Find Option replacement 1

Back
Top