• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Finding a Workbook File

If you forget where you saved a file, Excel can help you. You can use its Find Now option in the Open dialog box. Follow these steps to have Excel hunt for a file for you:

  1. Open the File menu and select Open, or click the Open button in the Standard toolbar. The Open dialog box appears (see Figure 8.2).

    Figure 8.2. The Search options in the Open dialog box enable you to specify what you want to search for.

  2. Open the Look In box and select the drive and/or folder you want to search. For example, if you select C:, Excel will search the entire C drive. If you select C: and then select the Excel folder, Excel searches only the EXCEL directory on drive C. You can select My Computer to search all the drives on your computer.

  3. Narrow your search using any of the following methods:

    If you want to search for a particular file, type its name in the File Name text box. You can use wild-card characters in place of characters you can't remember. Use an asterisk (*) in place of a group of characters; use a question mark (?) in place of a single character. (For example, if you enter sales??, Excel finds all files whose file names begin with the word "sales" followed by two characters, such as SALES01, SALES02, and so on.)

    You can search the contents of your workbooks for a particular phrase by typing it in the Text Or Property box. For example, type "brook trout" to find a workbook that contains the words "brook trout."

    To specify a time period for the files you want to search, choose an option from the Last Modified box.

    To have Excel search all subfolders of the drive you specify, click the Commands and Settings button and choose Search Subfolders from the pop-up menu that appears.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint