Solved Searching for linked information

Microsoft Excel 2010 (academic)
September 25, 2012 at 07:02:12
Specs: Windows
When linking a value from on spreadsheet to another IE - =spreadsheet name, value, you cannot search the actual data in the new spreadsheet, because the formula is there, not the name.

Is there any way, other than copying and pasting as a value to search for the actual text?

See More: Searching for linked information

September 25, 2012 at 07:43:35
✔ Best Answer
If your using Find on the ribbon,
After you select Find
select the Options button.

In the drop box labeled: Look In:
change it to: Values

See how that works.


Report •
Related Solutions

Ask Question