Page 69 - Excel Workbook for Dummies

08_798452 ch04.qxp 3/13/06 7:36 PM Page 52
52 Part I: Creating Spreadsheets

Try It

Exercise 4-2: Searching for the Workbook to Edit

This exercise gives you practice finding workbook files using both the Basic and
Advanced tabs on the File Search dialog box:

1. Display the Open dialog box (Ctrl+O) in Excel, click the My Documents button to
make this folder current, and then open the File Search dialog box (click Search
on the drop-down list attached to the Tools button).
2. Type Exer in the Search Text box on the Basic tab of the File Search dialog box
and then set up the following Search Options:
• My Computer and all its subfolders as the location to search in the Search
In drop-down list box
• Excel Files as the type of files to find in the Results Should Be drop-down
list box
• To restrict the location of the file search to My Computer and its subfold-
ers, click the Everywhere check box on the Search In drop-down list to
deselect it and all the other locations, and then click the My Computer
check box (the Search In drop-down list box will then read Selected
Locations).
• To restrict the type of files to be searched for to Excel files, click the
Anything, Outlook Items, and Web Pages check boxes to deselect them and
their associates and then click only the Excel Files check box under Office
Files. (The Results Should Be drop-down list box will then read, “Selected
File Types.”)
3. Select the Go button to begin searching for all the Excel files that contain Exer in
the filename within your My Computer folder and its subfolders.
When the file search stops, you will see a whole list of all the Exercise workbook
files that you copied from the workbook CD-ROM and that you created in doing
the exercises in previous chapters in the Results section at the bottom of the File
Search dialog box.
4. Delete the text Exer in the Search Text box on the Basic tab and then click the
Restore button on the Advanced tab of the File Search dialog box.
5. Using the Advanced tab, set up a Search for every workbook with a Category
that includes payroll:
To set up this search option, click Category in the Property drop-down list,
select Includes in the Condition drop-down list, and then type payroll in the
Value text box before you select the Add button.
6. Select the Go button to find all the Excel workbooks within your My Computer
folder and its subfolders whose Category summary information contains payroll.
When the File Search stops, you should see your Hourly Wages 02-06.xls file listed
in the Results section at the bottom of the dialog box.
7. Click the Hourly Wages 02-06.xls file listed in the Results section.

Note that a border now appears around the filename with a drop-down list
button on the right. When you mouse over this drop-down list button, a ToolTip
displaying the file’s entire path name appears.
8. Select the Properties item on file’s drop-down list to open the Hourly Wages
02-06.xls Properties dialog box and then click its Summary tab.