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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top