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

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.

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

"mathew" wrote:

> 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.
>
>

Guy,

Thank you for the help. That is exactly what I was looking for.

Mathew

"Guy Lydig" wrote:

> 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
>
> "mathew" wrote:
>
> > 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.
> >
> >