cntl+f does not find data that I can see in chart

M

mathew

I have two spreadsheets. In ss 1 there are names that are linked from ss 2.
When I use ctrl+f to find the names, they are not found, even though I can
see that they are there. Any help is appreciated.
 
G

Guy Lydig

It is not finding it in the usual way because it is not really there. If you
click the cell you will see the formula bar says Sheet1!A1 or whatever the
cell is.

To allow Control+f to find text, in the Find dialog box, click Options to
expand the box. Under Look in: change Formulas to Values. That should do it.

HTH

Guy
 

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

Converting decimal degrees to degrees, minutes & seconds 2
Create a dynamic master file 1
Creating a Chart on form from selected data in query. 0
Integrating information from Word to Excel (not mail merge) 1
Possible to Combine reports to's to a single box? 0
Excel - Wich Function should I use? 1
Finding the right style field in VBA 0
How do I set focus (and select text) on a text box on a modeless userform? 0

Top