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. |
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. |
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. |
All times are GMT +1. The time now is 04:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com