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

's Computer Specifications

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.

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When is MSFT going to update CNTL-F to do a "find" in Outlook?	Mark	Microsoft Outlook Discussion	3	11th Sep 2009 08:30 PM
Find and replace data in an Excel chart object	=?Utf-8?B?Q2F3ZW4=?=	Microsoft Excel Charting	2	31st Mar 2005 06:47 PM
Editing real chart data not fake chart data	=?Utf-8?B?TmVvQWxjaGVteQ==?=	Microsoft Access Reports	1	13th Jan 2005 07:09 PM
Excel - cntl-F "find" shows up in center. Can it be set to move to	=?Utf-8?B?U29ubnlCdWJiYQ==?=	Microsoft Excel Misc	1	8th Nov 2004 04:11 PM
Chart Data Table, Data Range, etc. do not update on Chart	=?Utf-8?B?UmljaGFyZFM=?=	Microsoft Excel Charting	3	17th Dec 2003 05:56 PM