• Home
  • About

Entries RSS | Comments RSS
  • Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

  • Categories

  • Archives

  • Recent Posts

    • Create Single Click Desktop Icons
    • Open a Second Window in Outlook 2007
    • Excel Twitters 20090103
    • Excel Twitters 2008127
    • Have an Excellent Christmas!
  • Pages

    • About
  • Subscribe in a reader

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:

  1. In Excel, click on the File menu, and click on Properties
  2. 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:

  1. In Excel, click the Open button on the toolbar.
  2. At the top right of the Open dialog box, click the arrow on the Tools button
  3. Click Search
  4. In the Search dialog box, click the Advanced tab.
  5. From the first drop down, select Keywords
  6. Enter a keyword in the third box, and click Add
  7. Enter more keywords, or any other search criteria, including location.
  8. Click the Go button, to start the search.

Share/Save/Bookmark

Filed under: Excel, File Management

« On-line Stop Watch Calculator at Your Fingertips »

4 Responses to “Find Office Files with Keywords”


  1. Comment from Mike Alexander
    Time: June 26, 2008, 12:48 pm

    Interesting. I can’t seem to find this in Excel 2007. Removed Functionality?


  2. 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


  3. 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?


  4. 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.

Leave a Reply

  • Subscribe

    Subscribe in a reader
  • Email Updates

    Subscribe by Email
  • Calendar

    June 2008
    S M T W T F S
    « May   Jul »
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  
  • Contextures

    • Contextures Excel Pages
    • My Video Tutorials
  • Excel

    • Daily Dose of Excel
    • Excel Team Blog
    • Jan Karel Pieterse
    • JP’s Excel/Outlook
    • PTS Blog
    • Spreadsheet Page Blog
    • TVMCalcs Excel Blog
  • General

    • Hodge Blog
    • J-Walk Blog
    • SuiteMinute