Here's our Microsoft Office Tip for.. July 21, 2003
Click Here to see a complete list of all of our previously released Tips!
Finding Files by Their Properties
You don't have to leave Excel to run a sophisticated search for a file. If you've entered properties for your files--who created them, when the files were created, and other keywords about them--you can search on these elements.
To do so, first choose File, Open. In the Open dialog box, select the Find command from the Tools drop-down list. In the Find dialog box, click the Property drop-down menu and choose a property, such as Keyword. In the Value text box, enter the keyword you're searching for. Then, on the Look In line, specify the drive (or folder) to search. Finally, click the Find Now button.