none
Microsoft Excel cannot find the data you're searching for

    질문

  • I have a sheet in and Excel file with a lot of data in it.

    When I try to search for a word in this particular sheet I get: "Microsoft Excel cannot find the data you're searching for" even for words that are present in the sheet.

    when I go to other sheets  in the file search function works properly.

    What's going on?

    thanks

     

    2011년 9월 4일 일요일 오후 4:01

답변

  • Hi

    In the Find dialog click the Options button and check the options for matching case, match entire cell contents.

    Also look at what you have selected when you try to use search.  If you have more than one cell selected then the search is restricted to the selected cells.


    G North MCT
    2011년 9월 5일 월요일 오전 8:02

모든 응답

  • Hi

    In the Find dialog click the Options button and check the options for matching case, match entire cell contents.

    Also look at what you have selected when you try to use search.  If you have more than one cell selected then the search is restricted to the selected cells.


    G North MCT
    2011년 9월 5일 월요일 오전 8:02
  • Hi,

    The problem was caused by the Excel feature “Find by format” feature (red dot).  To turn it off, click on the Format button (green dot), and then select the Clear option.

    Sandeep

    • 답변으로 제안됨 Sandeep Kotalwar 2012년 6월 9일 토요일 오전 9:05
    2012년 6월 9일 토요일 오전 9:04
  • Hi,

    The problem was caused by the Excel feature “” feature (red dot).  To turn it off, click on the Format button (green dot), and then select the Clear option.

    Sandeep

    Hi, 

    Thanks for the answer this made my day

    2012년 12월 24일 월요일 오후 4:53
  • Hi Your solution worked. the others did not for me

    Thanks

    Bhadra 

    2016년 7월 1일 금요일 오후 11:18
  • Here's another possibility:  I copy pasted some text into the find box.  When it didn't work, I created a macro and clicked replace again, then looked at the macro.  Found it was searching for this:

    Replace What:="the text I had copied" & Chr(10) & "",

     it had added in a line break code, which wasn't visible in the search box!  (There was NO LINE BREAK adjacent to the text I had copied, no idea how it got there.)

    So, if all else fails, try copying the text you want to find to notepad then re-copy the text from notepad into the find box.


    • 편집됨 Piecevcake 2016년 8월 30일 화요일 오후 9:44
    2016년 8월 30일 화요일 오후 9:38