| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace looking for values
Hi,
When I'm in Excel03 and try to find a value (which I know is there) it returns "MS Excel cannot find the data you're searching for." I've found that in options you can change "Look in:" from formula to values. My question is, can I make the "Look in:" option default to values instead of formula, as 99% of my find and replace is for values and not formulas. Thanks in advance. AW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace nonzero values with 1 | Excel Worksheet Functions | |||
| Find/Replace hundreds of values | Excel Discussion (Misc queries) | |||
| Find replace hyperion Values | Excel Discussion (Misc queries) | |||
| Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
| How do I find and replace "values" (like #N/A) in a worksheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
