peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Find Office Files with Keywords

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.
Related Posts Plugin for WordPress, Blogger...

4 comments to Find Office Files with Keywords

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>