Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm using Microsoft Office 2007. How can I search inside multiple Excel files?

share|improve this question
add comment

3 Answers

With the folder that houses the files open, press Ctrl+f to use the search box in the folder. Then search for

content:"my string to search for"

to search for that string in the files in the current directory.

share|improve this answer
add comment

In Excel 2003 you had an extra search option in the file menu where you were able to search through files. I can't find this option in 2007 anymore so I think it's gone.

If your have Vista or Windows 7 you should be able to use window's integrated search. In older versions you could install a search app like Windows Desktop Search, Google Desktop Search, Copernic, ... they're all free to use.

share|improve this answer
    
In Win 7 you can specify a type:xlsx parameter in the search box (or xls, etc. as appropriate) –  jonsca Jul 21 '11 at 11:42
    
@jonsca, OP question was about searching inside not searching for excel files. –  Peter Nore May 15 '12 at 14:09
    
@PeterNore Yes, the comment was a supplement to If your have Vista or Windows 7 you should be able to use window's integrated search. If you specify the file type or the extension in addition to your "content:" string it doesn't have to search the entire directory, just the pertinent files. –  jonsca May 15 '12 at 16:12
add comment

Use IceTeaReplacer. It's freeware.

Search & Replace in .docx, .xlsx and .xls files

IceTeaReplacer is a simple, yet a powerful tool to search inside multiple Microsoft's Office Word 2007 (docx), Excel 2007 (xlsx) and Excel 2003 (xls) files within a directory (and it's subdirectories) and replace provided phrase. Supports UTF-8.

enter image description here

There is also a more powerful alternative with various features but it's a commercial one: ExcelPipe.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.