Ray707
08-26-2021, 03:12 AM
Hi all,
I'm wondering if you can help. I use the 'find and replace' function a lot in excel in my new job but when I click on 'ctrl F' to open this function up, the part that says 'look in' is set to 'formulas'. This drove me crazy yesterday as I was validating data in a file and trying to search for unique identifiers but it kept saying the values were not in there when I knew it 100% was. Eventually I realised that it was due to the fact that the 'look in' was set to 'formulas' instead of 'values'. I have never experienced this problem before with excel- how can I change it to values and maintain that moving forward? It keeps reverting back.
I found a picture of what I am referring to on google. The 'look in' part needs changing to always say 'values':
https://support.content.office.net/en-us/media/f3f1e67a-874e-4944-a2ce-17e08ab3d2a7.jpg
Thanks :thumb
I'm wondering if you can help. I use the 'find and replace' function a lot in excel in my new job but when I click on 'ctrl F' to open this function up, the part that says 'look in' is set to 'formulas'. This drove me crazy yesterday as I was validating data in a file and trying to search for unique identifiers but it kept saying the values were not in there when I knew it 100% was. Eventually I realised that it was due to the fact that the 'look in' was set to 'formulas' instead of 'values'. I have never experienced this problem before with excel- how can I change it to values and maintain that moving forward? It keeps reverting back.
I found a picture of what I am referring to on google. The 'look in' part needs changing to always say 'values':
https://support.content.office.net/en-us/media/f3f1e67a-874e-4944-a2ce-17e08ab3d2a7.jpg
Thanks :thumb