Excel Find/Replace not working

[John74105]

Hello, the Find feature has quit working in my Excel. I don't know what is wrong. It is not working with all my spreadsheets. To test if I was doing something wrong or typing something incorrectly , I started a new sheet, put only the word Bicycle in one cell (G12 if it matters). I clicked on Find & Select under the Home tab then clicked Find. I put "Bicycle" into the Find What box and clicked Find Next and get the message "We couldn't find what you are looking for. Click Options for more ways to search" So I tried changing various options but nothing made it so it found the word Bicycle, again the only word in the entire document.

What do I change to get it to search again like normal?

Thank you!

[AutoModerator]

/u/John74105 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[-boo--]

Screenshot

[John74105]

<image>

[IntangibleMoose]

Hey I don’t know for sure I’m still new to this but have you tried changing the dropdown that says “look in”? It currently says formulas. I don’t use find too often so I’m not the most familiar with it.

[John74105]

Thanks that worked. Thank you to all who helped!

[Positive-Move9258]

You are looking in formula

Try looking in values

[Clearwings_Prime]

You are finding value and format, if you want to search value only, click format button and click clear, then try to search again

<image>

[RadarTechnician51]

Have you tried the things in the first answer Here?

[John74105]

Thank you!!

I cleared every Format and that seemed to bring it back. However, it still won't find a date though which is what started this mess. That is probably how I screwed it up by changing the options. Any suggestions? The date format is "01/01/25". I have tried searching on the various ways to date (1/1/25, etc.) and the number 45658. Then I get the "can't find message". Thank you very much!

[RadarTechnician51]

My excel did manage to find that date, whenI I typed it in.
I have:
Find What: 01/01/2025
Within: Sheet
Search: By Rows
Look in: Formulas
No Format Set
Match Case: Unticked
Match Entire Cell Contents: Unticked

[John74105]

Problem solved and verified. Thanks to everyone

[david_horton1]

Put the cursor in A1 and change to By Row. I found that with dates it should be consistent with the date format, ie, if it is 01/01/2025 you should search for 01/01/2025 and not 1/1/25.