Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Workbooks > File Search< Previous | Next > 
 

Searching for Files

 
 

You can use Windows Explorer to browse between folders and to find particular files.

 
 

You can also use find files using any of the following:

 
 

  • Basic File Search Task Pane

    		 
     

  • Advanced File Search Task Pane

    		 
     

  • File Search Dialog Box

    		 

     

    Basic File Search Task Pane

    		 
     

    This can be used to find files:

    		 
     

    1) containing various words or phrases in the file names and actual content

    		 
     

    2) located on your computer or on shared networks.

    		 
     

    You can display the Basic File Search task pane by selecting (File > File Search).

    		 
     

     Search text -

     Go -

     Restore -

     Search tips -

     Search in - Lets you type in the exact folder path or select from one of the following options:

     Everywhere - searches all the drives on your computer and on any shared networks.

     My Computer - searches all the drives on your computer.

     My Network Places - searches all the drives on shared networks.

     Outlook - searches all the email messages, appointments, contacts, tasks and notes.

     

     Results should be - (see below). Click outside the list once you have made your selection.

     Search options -

     Advanced File Search

     Research -

     Find in this document -

    		 
     

    You can use multiple clicks in the search in drop-down to select what you want.

    		 
     

    By default this task pane will display the last search you performed.

    		 

     

    Advanced File Search Task Pane

    		 
     

    This can be used to find files:

    		 
     

    1) by searching in the File Properties

    		 
     

    2) in specific locations

    		 
     

    3) that are specific file types.

    		 
     

    You can display the Advanced File Search task pane by clicking on the Advanced File Search link at the bottom of the Basic File Search task pane.

    		 
     

     Property -

     Condition -

     Value -

     Add -

     Remove -

     Remove All -

     Go -

     Restore -

     Search in -

     Results should be -

     Anything - includes all files not those just associated with Microsoft Office.

     Office Files - includes the files associated with Microsoft Office.

     Outlook Items - includes all email messages, appointments, contacts, tasks and notes

     Web Pages - includes (.html) and (.htm) and other web related files such as (.asp, .aspx, .mht, .mhtml)

     

     Basic File Search

     Research -

     Find in this document -

    		 

     

    File Search Dialog

    		 
     

    This dialog box offers the same functionality as the two task panes.

    		 
     

    You can display the File Search dialog box from inside the (File > Open) dialog box.

    		 
     

    In the Open dialog box choose (Tools > Search).

    		 
       

     

    Things to Remember

    		 


     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >