+ Reply to Thread
Results 1 to 28 of 28

Find (Ctrl + F) and Replace Not Working

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    22

    Find (Ctrl + F) and Replace Not Working

    I have been experiencing a very frustrating problem with excel's Ctrl+f.... I cannot find #'s anymore, only text.... I can't find values even when they are in view on the sheet and I type the exact value I'm looking at... I have tried ALL combinations of options in the Ctrl+F box....

    Anybody else ever experience this problem, and how did you fix it?!?

    Thanks in advance for you help!

    Cheers and have a nice weekend

    -Snolem-

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Find (Ctrl + F) and Replace Not Working

    Hi and welcome to the forum

    when you press CTRL F, select the options and see whats seleced in the 3 options there, as well and make sure both "match case" and "match entire contents" are not selected.

    Under the 3 options, I have...
    Sheet
    By rows
    Formulas (you might want tp change this to values)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    22

    Re: Find (Ctrl + F) and Replace Not Working

    Thank you for your quick reply! Unfortunately, I have gone through all of those options and the find feature is still not working to find numbers that I know exist because I'm looking at them on my screen trying to get the find feature to work.

    Anybody else?

    Thanks again!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Find (Ctrl + F) and Replace Not Working

    can you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what you are searching for
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

  5. #5
    Registered User
    Join Date
    08-21-2012
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    22

    Re: Find (Ctrl + F) and Replace Not Working

    Thanks again! ... Attached you'll find a file and two screen shots of my searches performed both by values and in formulas without finding the result that is I know to be there because I'm looking at it...

    Cheers!

    Values.jpgMatch Formulas.jpg
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Find (Ctrl + F) and Replace Not Working

    Hello,

    You are trying to find the value in a formula.

    What you can do is, when you press Ctrl-F, check on "Match entire cell contents", and most importantly, under "Look in", instead of "Formula", choose "Values".
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  7. #7
    Registered User
    Join Date
    08-21-2012
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    22

    Re: Find (Ctrl + F) and Replace Not Working

    Thanks for the awesomely quick response Lemice!

    Unfortunatley, I have tried every iteration of options possible... Attached is the screenshot of your suggested options, but to no avail ...

    Any other ideas!?!

    Thanks again guys


    Match Entire Cell Contents.jpg

  8. #8
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Find (Ctrl + F) and Replace Not Working

    For some reason I have to enter exactly 61,397.00, and uncheck "Match entire cells only", only by then it shows up ...

    This is weird, maybe it's just Excel being Excel.

  9. #9
    Registered User
    Join Date
    08-21-2012
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    22

    Re: Find (Ctrl + F) and Replace Not Working

    Good to know... This is strange, but at least I now have a work-around

    Cheers to you Lem and everyone else for helping!

  10. #10
    Registered User
    Join Date
    12-05-2014
    Location
    hosur
    MS-Off Ver
    2010
    Posts
    1

    Re: Find (Ctrl + F) and Replace Not Working

    Hello ,

    Kindly check the attached file screen shot . I hope this should be helpful for you. if this is the root cause means
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    07-28-2017
    Location
    VIJAYAWADA
    MS-Off Ver
    14.0.4734.1000 (32-bit)
    Posts
    1

    Re: Find (Ctrl + F) and Replace Not Working

    Hi sir,

    this is praveen from vijayawada i have problem find & replace option in excel 2010,i am finding repeated one word but only once find then cursor is go through excel sheet not find another word please help sir
    thanks & regads
    ch v praveeen

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Find (Ctrl + F) and Replace Not Working

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  13. #13
    Registered User
    Join Date
    12-04-2013
    Location
    US
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Find (Ctrl + F) and Replace Not Working

    I have found that sometimes, you must search in the format of the cell.

    In my experience, I did some cohort analysis calculating repeat % and when I try to remove all 0 values from the results, I had to search for '0%' instead of just 0 because the results were formatted in Percentage.

  14. #14
    Registered User
    Join Date
    08-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Find (Ctrl + F) and Replace Not Working

    I think this is a window bug. I have office 2016 installed both on my laptop(win10 home) and desktop (win7pro). Using the same workbook, find and replace work perfectly on my laptop but not on my desktop. The desktop was on office 2013 before and find and replace was not working. That was why I upgrade the desktop to office 2016 but still not working. So by elimination, I say it is win 7 issue. I hope this helps.

  15. #15
    Registered User
    Join Date
    10-04-2018
    Location
    Montana
    MS-Off Ver
    2013
    Posts
    2

    Re: Find (Ctrl + F) and Replace Not Working

    Hit CTRL+F, Options, Format, and ensure the Clear button is grayed out for every tab.

  16. #16
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Find (Ctrl + F) and Replace Not Working

    Try searching for 22,577.94

  17. #17
    Registered User
    Join Date
    10-04-2018
    Location
    Montana
    MS-Off Ver
    2013
    Posts
    2

    Re: Find (Ctrl + F) and Replace Not Working

    it works, just type CTRL+F - then 22577.94 --omit the comma

  18. #18
    Registered User
    Join Date
    08-14-2018
    Location
    Ottawa, Canada
    MS-Off Ver
    Windows 10
    Posts
    4

    Re: Find (Ctrl + F) and Replace Not Working

    Your clear tab worked perfectly....THANK YOU!

  19. #19
    Registered User
    Join Date
    08-14-2018
    Location
    Ottawa, Canada
    MS-Off Ver
    Windows 10
    Posts
    4

    Re: Find (Ctrl + F) and Replace Not Working

    Your Clear button solution worked perfectly. THANK YOU!

  20. #20
    Registered User
    Join Date
    02-26-2020
    Location
    Aberdeen
    MS-Off Ver
    Windows
    Posts
    1

    Re: Find (Ctrl + F) and Replace Not Working

    Hello,

    When I click ctr+f, it highlights the sheet itself, how do I change it to values?

    Thank you,
    Ingrida

  21. #21
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Find (Ctrl + F) and Replace Not Working

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

  22. #22
    Registered User
    Join Date
    08-14-2018
    Location
    Ottawa, Canada
    MS-Off Ver
    Windows 10
    Posts
    4
    Quote Originally Posted by Ingri View Post
    Hello,

    When I click ctr+f, it highlights the sheet itself, how do I change it to values?

    Thank you,
    Ingrida
    Control f does find control a selects all

  23. #23
    Registered User
    Join Date
    04-18-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 2013
    Posts
    1

    Re: Find (Ctrl + F) and Replace Not Working

    This happens to me and I think I finally found a workaround. For whatever reason, if you type the what you're searching for anywhere on the page, "Find All" is able to find all of the options (not just the new one you typed)

    Good luck! This finally helped me from a very aggravating project. (Especially because I was closing the program after every search, which helped as well).

  24. #24
    Registered User
    Join Date
    07-28-2020
    Location
    Fareham, England
    MS-Off Ver
    Excel365
    Posts
    29

    Re: Find (Ctrl + F) and Replace Not Working

    Quote Originally Posted by vanderpooldr View Post
    Hit CTRL+F, Options, Format, and ensure the Clear button is grayed out for every tab.
    Thank you!! This had been driving me nuts!

  25. #25
    Registered User
    Join Date
    05-28-2021
    Location
    Calgary Canada
    MS-Off Ver
    Office 365
    Posts
    1

    Thumbs up Re: Find (Ctrl + F) and Replace Not Working

    Works like a charm.

    Thanks so much!

  26. #26
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Find (Ctrl + F) and Replace Not Working

    Ali, now I understand why Forum Rule #4 is so important.. this whole thread is all jumbled up!

  27. #27
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    2013
    Posts
    18

    Re: Find (Ctrl + F) and Replace Not Working

    Here is what I would recommend you to do , check that your search options are set to look in Values, not Formulas. Make sure you don't have multiple cells selected (otherwise, Search will only look in selected cells). Make sure "Match whole cell" isn't selected. I hope this helps! Cheers!

  28. #28
    Registered User
    Join Date
    04-07-2022
    Location
    Sydney, Oztralia
    MS-Off Ver
    365
    Posts
    1

    Re: Find (Ctrl + F) and Replace Not Working

    [QUOTE=WisconsinElle;5315894]This happens to me and I think I finally found a workaround. For whatever reason, if you type the what you're searching for anywhere on the page, "Find All" is able to find all of the options (not just the new one you typed)

    Nothing else here mentioned worked until I found your post. It took me a minute to decipher what you were saying but when I selected all and searched for a different word outside my original selection "Find" started working again. When I returned to my selection and original search phrase it also worked. Thanks very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1