| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
cntl+f does not find data that I can see in chart
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
cntl+f does not find data that I can see in chart
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Selecting part of a series for a chart? | Charts and Charting in Excel | |||
| I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
