Find Office Files with Keywords
Posted on June 25th, 2008 by Debra Dalgleish
When you save a Microsoft Office file, you can store keywords to help you find that file later. For example, when you’re creating an estimate for a client’s Excel project:
- In Excel, click on the File menu, and click on Properties
- On the Summary tab, enter Estimate, Excel in the Keywords box, then click OK.
Later, you can use one or more keywords to find relevant files:
- In Excel, click the Open button on the toolbar.
- At the top right of the Open dialog box, click the arrow on the Tools button
- Click Search

- In the Search dialog box, click the Advanced tab.
- From the first drop down, select Keywords
- Enter a keyword in the third box, and click Add

- Enter more keywords, or any other search criteria, including location.
- Click the Go button, to start the search.
Filed under: Excel, File Management


Comment from Mike Alexander
Time: June 26, 2008, 12:48 pm
Interesting. I can’t seem to find this in Excel 2007. Removed Functionality?
Comment from admin
Time: June 26, 2008, 3:49 pm
Mike, in Excel 2007 click the Office button.
Then click Prepare, and click Properties.
The property boxes appear above the worksheet.
Debra
Comment from Mike Alexander
Time: June 26, 2008, 4:23 pm
I meant to say that the Open dialog box doesn’t seem to have the Search tool. Maybe it’s just my version?
Comment from admin
Time: June 26, 2008, 7:13 pm
Hey, it’s missing in my version too! All you can do is view the properties of a file that you select, which isn’t much help.