Searching for Words in Excel

exalted512
exalted512 Posts: 10,735
edited October 2011 in The Clubhouse
If I have a folder full of Excel files, how do i search for words IN the document itself from the folder?

-Cody
Music is like candy, you have to get rid of the rappers to enjoy it
Post edited by exalted512 on
· Share on FacebookShare on Twitter

Comments

  • thsmith
    thsmith Posts: 6,082
    edited October 2011
    I have a folder with Excel files. I right clicked on folder and selected search.

    Then the search menu comes up, make sure the location is your excel folder with the files you want to seach.

    Then put your key word you are searching for in the search bar next to the location.

    I am using office 2007, YMMV.
    Speakers: SDA-1C (most all the goodies)
    Preamp: Joule Electra LA-150 MKII SE
    Amp: Wright WPA 50-50 EAT KT88s
    Analog: Marantz TT-15S1 MBS Glider SL| Wright WPP100C Amperex BB 6er5 and 7316 & WPM-100 SUT
    Digital: Mac mini 2.3GHz dual-core i5 8g RAM 1.5 TB HDD Music Server Amarra (memory play) - USB - W4S DAC 2
    Cables: Mits S3 IC and Spk cables| PS Audio PCs
    · Share on FacebookShare on Twitter
  • exalted512
    exalted512 Posts: 10,735
    edited October 2011
    I'm not sure we're talking about the same thing.

    I'm on win7 with office 2010. I dont remember having this issue with XP, but I could be wrong.

    I'm in 'My Computer' with a folder full of excel files. If I right click that folder, no 'search' option is available. If I open that folder and use the search bar at the top right, it ONLY searches titles, not content :(
    -Cody
    Music is like candy, you have to get rid of the rappers to enjoy it
    · Share on FacebookShare on Twitter
  • thsmith
    thsmith Posts: 6,082
    edited October 2011
    Yeah, I am on XP. Sorry. Have Windows 7 at home but I am at work on XP.
    Speakers: SDA-1C (most all the goodies)
    Preamp: Joule Electra LA-150 MKII SE
    Amp: Wright WPA 50-50 EAT KT88s
    Analog: Marantz TT-15S1 MBS Glider SL| Wright WPP100C Amperex BB 6er5 and 7316 & WPM-100 SUT
    Digital: Mac mini 2.3GHz dual-core i5 8g RAM 1.5 TB HDD Music Server Amarra (memory play) - USB - W4S DAC 2
    Cables: Mits S3 IC and Spk cables| PS Audio PCs
    · Share on FacebookShare on Twitter