Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find - Entire Cells only
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 |
#2
|
|||
|
|||
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? Andibevan wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
I think you are right - it may also have something to do with whether you
save the document as well. Thanks Andi "Dave Peterson" wrote in message ... 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? Andibevan wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Find cells with ? | Excel Discussion (Misc queries) | |||
Find cells without multiple spacebars and format... | Excel Discussion (Misc queries) | |||
Find all cells with a number and mulitply | Excel Discussion (Misc queries) |