Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - "Find" Feature
My "Find" feature does not appear to be working on a specific spreadsheet. I
use it to look for a number that I know is there and I get a message back stating Microsoft cannot locate. What can I do to correct problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - "Find" Feature
When using Find, if you have more than one cell selected in a worksheet then
Find only looks in the selected range. Therefore ensure that you only have one cell selected or that you have the entire range to search selected. Also check that the number you are looking for is not in text format with a leading or trailing space or other non visible character. Uncheck the box for Match entire cell contents should establish if this is the problem. Perhaps others have some more ideas for you to check. -- Regards, OssieMac "ManhattanRebel" wrote: My "Find" feature does not appear to be working on a specific spreadsheet. I use it to look for a number that I know is there and I get a message back stating Microsoft cannot locate. What can I do to correct problem? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - "Find" Feature
Also, double check the lookin dropdown box. Are you searching the cell
values or formulas?? "ManhattanRebel" wrote: My "Find" feature does not appear to be working on a specific spreadsheet. I use it to look for a number that I know is there and I get a message back stating Microsoft cannot locate. What can I do to correct problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
How to change the default in Excel from "find next" to "find all" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Can you add the "Change Case" feature to Excel on future versions | Excel Discussion (Misc queries) | |||
Can the "Find and Replace" feature be used in Formulas somehow? | Excel Worksheet Functions |