Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Find function not working?

  1. #1
    Board Regular
    Join Date
    Oct 2007
    Posts
    109
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Find function not working?

    I have a sheet with a list of names on and I've noticed that when I use ctrl+F to use the find function, even when I know i have entered the correct name it still will not work. I have identifed times when I know the name is there on the sheet, but the find function says "Excel cannot find the data you are searching for"

    Im unable to put any pics up as my work pc has java disable so photobucket ect won't work but has anyone else come across this problem and how did you rectify it? A search macro perhaps?

  2. #2
    MrExcel MVP
    Moderator
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Find function not working?

    Hi

    Do you only have a single cell selected at the time you run Find? Also, make sure via the Options button when you go to Find that you don't have "Match entire cell contents" checked (or possibly the "Match case" option either)
    Richard Schollar

    Using xl2013

  3. #3
    Board Regular
    Join Date
    Oct 2007
    Posts
    109
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Find function not working?

    Yes just a single cell selected and the 2 check boxes are not populated. If it would be more helpful I have taken a screen dump which I can upload later from my personal pc?

  4. #4
    MrExcel MVP
    Moderator
    Inactive
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Find function not working?

    I'm not sure why it wouldn't be working - have you tried the usual things of closing and reopening the workbook? Go ahead and post a screenshot - hopefully someone will have an idea what the problem is.
    Richard Schollar

    Using xl2013

  5. #5
    New Member
    Join Date
    Oct 2017
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Find function not working?

    You can try also to select all then make find.
    try this. press ctrl+a 2 times then you can find the word now by
    pressing ctrl+f.

  6. #6
    MrExcel MVP ZVI's Avatar
    Join Date
    Apr 2008
    Location
    Sevastopol
    Posts
    3,407
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Find function not working?

    May be Find format was set previously.
    Try Ctrl-F - Format - Clear Find Format
    Vladimir Zakharov
    Microsoft MVP Office Apps & Services

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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