Datasheet

Search for a File by Properties
1. Choose File➪Open. The Open dialog box appears.
2. Click the Tools button and choose Search from the menu.
3. In the File Search window, click the Advanced tab.
4. Select the field you want to search from the Property
drop-down list.
5. In the Value box, enter the data by which you want to
search.
6. Click the Add button.
7. Select where to search from the Search In drop-down list.
8. Select the file types you want to look for from the Results
Should Be drop-down list as shown in Figure 1-13.
9. Click the Go button. A list of the files matching your
criteria appears at the bottom of the File Search window.
Save or Open Files in Different
Formats
1. Choose File➪Save As or File➪Open.
2. Select a location in which to save the file or the location
in which your file is currently located.
3. Select the file type you want to use from the Save as Type
(shown in Figure 1-14) or Files of Type drop-down list.
4. Enter a name for the file in the File Name text box or
select the file you want to open.
5. Click Save or Open.
Figure 1-13: Searching for file by property values
Figure 1-14: Save a workbook as a different file type
➟
12
Chapter 1: Working with Excel Files
05_574884 ch01.qxp 3/7/06 9:57 PM Page 12