Windows 10: search file explorer for text inside of a spreadsheet

Discus and support search file explorer for text inside of a spreadsheet in Windows 10 Network and Sharing to solve the problem; I have a folder which contains spreadsheets from my vendor. Each one has a list of invoices for a period of time. I'm trying to search the folder... Discussion in 'Windows 10 Network and Sharing' started by ZenMasta, Jun 20, 2020.

  1. ZenMasta Win User

    search file explorer for text inside of a spreadsheet


    I have a folder which contains spreadsheets from my vendor. Each one has a list of invoices for a period of time.


    I'm trying to search the folder using file explorer for a specific invoice number but there are no search results. To rule out the possibility that the record doesnt exist because I didn't save that spreadsheet. I opened one and searched for a record which I know exists but it still said "No items match your search".


    Also just in case it had anything to do with the search not working, I disabled protected view for files from the internet and potentially unsafe locations


    https://medium.com/lets-excel/microsoft-excel-how-to-disable-protected-view-in-ms-excel-ae01a0c5405b#:~:text=%20Steps%20to%20Disable%20Protected%20View%20%201,%E2%80%9CFile%E2%80%9D%20menu%20option%202%20Select%20%E2%80%9COptions%E2%80%9D%20More%20


    However I don't know if it needs time to reindex, or how to force a reindex.



    [Moved from Excel / Windows 10 / Microsoft 365 Apps or Office 365 Business]

    :)
     
    ZenMasta, Jun 20, 2020
    #1

  2. File Explorer Search Not Working


    I am trying to search in File Explorer (Windows Explorer, My Computer) and it will not find anything. I can copy text from a name in the list and paste it in the search box and it still finds nothing. I have looked at the suggestions that have been posted and nothing I find that is relative to this works. Anyone have any suggestions? I am running Win 10 Pro on an I3 coustom desktop computer.
     
    Maestro2711, Jun 20, 2020
    #2
  3. setting default view for Winodws Explorer Search Reasults

    Thank you for the detailed response. To change the search result's view from content to list, we suggest following the steps below:

    • Open the File Explorer and try to search for files.
    • In the toolbar, open the View tab and click List
      to change the view.
    • Once changed, close the File Explorer.
    • Open the File Explorer again and try to search to see if the setting has been retained.

    After performing the steps above, reply back to us so we can provide additional help.
     
    Jennifer Cha, Jun 20, 2020
    #3
  4. Nikhar_K Win User

    search file explorer for text inside of a spreadsheet

    Search for Missing files in File Explorer

    Hi,

    Thank you for writing to Microsoft Community Forums.

    I understand that you are looking for a file named “Class” with the length of the file. However, currently File Explorer doesn’t have the option to search the files using the length.

    You can follow the steps mentioned below to search for a file in File Explorer using the Size, Kind of file and other options.

    1. Press and hold Windows key + E to open
      File Explorer.
    2. Click on This PC on the left pane.
    3. Press F3 key to open Search options.
    4. You can select the Size,
      Kind
      of file and other options and then, search for the file.

    Hope it helps.

    Please reply with the status of the issue, we will be glad to help you further.

    Nikhar Khare

    Microsoft Community - Moderator
     
    Nikhar_K, Jun 20, 2020
    #4
Thema:

search file explorer for text inside of a spreadsheet

Loading...
  1. search file explorer for text inside of a spreadsheet - Similar Threads - search file explorer

  2. Windows 10 Explorer is not searching inside the text properly on my indexed SSD drive

    in Windows 10 Software and Apps
    Windows 10 Explorer is not searching inside the text properly on my indexed SSD drive: Hi all, this is my first post here. Here's the problem:I've just installed an SSD drive Kingston and copied a folder of pdfs into it; but when searching words via Explorer, only a small portion of files are showing when many more have that word inside the text all files that...
  3. Windows 10 Explorer is not searching inside the text properly on my indexed SSD drive

    in Windows 10 Network and Sharing
    Windows 10 Explorer is not searching inside the text properly on my indexed SSD drive: Hi all, this is my first post here. Here's the problem:I've just installed an SSD drive Kingston and copied a folder of pdfs into it; but when searching words via Explorer, only a small portion of files are showing when many more have that word inside the text all files that...
  4. Windows 10 Explorer is not searching inside the text properly on my indexed SSD drive

    in Windows 10 Gaming
    Windows 10 Explorer is not searching inside the text properly on my indexed SSD drive: Hi all, this is my first post here. Here's the problem:I've just installed an SSD drive Kingston and copied a folder of pdfs into it; but when searching words via Explorer, only a small portion of files are showing when many more have that word inside the text all files that...
  5. Windows File Explorer search not finding text in files that is obviously there

    in Windows 10 Gaming
    Windows File Explorer search not finding text in files that is obviously there: After looking at the numerous inquiries about how to make this work and being unsuccessful, and not wanting to waste a lot of time trying to make it work, I resorted to using the following MS-DOS command:FOR /F %i IN 'FINDSTR /M "string-to-be-searched" *.txt *.tmp' DO...
  6. Windows File Explorer search not finding text in files that is obviously there

    in Windows 10 Software and Apps
    Windows File Explorer search not finding text in files that is obviously there: After looking at the numerous inquiries about how to make this work and being unsuccessful, and not wanting to waste a lot of time trying to make it work, I resorted to using the following MS-DOS command:FOR /F %i IN 'FINDSTR /M "string-to-be-searched" *.txt *.tmp' DO...
  7. Windows File Explorer search not finding text in files that is obviously there

    in Windows 10 Network and Sharing
    Windows File Explorer search not finding text in files that is obviously there: After looking at the numerous inquiries about how to make this work and being unsuccessful, and not wanting to waste a lot of time trying to make it work, I resorted to using the following MS-DOS command:FOR /F %i IN 'FINDSTR /M "string-to-be-searched" *.txt *.tmp' DO...
  8. windows search inside file

    in Windows 10 Network and Sharing
    windows search inside file: despite turning on all the options, windows still won't search inside the pdf I have on my desktop. I use one drive so basically desktop is a one drive folder.I tried indexing options, enhanced search. All these options do is sometimes search in a .txt file. Coming from Mac...
  9. File Explorer Search Window Too Small To See Text

    in Windows 10 Network and Sharing
    File Explorer Search Window Too Small To See Text: I use the File Explorer search window frequently. Recently, I have noticed that the search box window is so small that when you start typing in the window, it is nearly impossible to see the text. The window is so small as to be nearly non-functional. I have had the same...
  10. Searching for duplicate text strings in File Explorer - Windows 10

    in Windows 10 Network and Sharing
    Searching for duplicate text strings in File Explorer - Windows 10: I've several external data drives with many, many files and directories. Many files are duplicated and I would like to eliminate the duplicates. The syntax for the duplicates is, for example: "file name n.docx" where n is a number, usually 1, 2 or 3. Using the community...