Datasheet

Delete a File
1. Open Excel, but not the file you want to delete. Choose
Office Button➪Open or Office➪Save As. Either the
Open or Save As dialog box appears.
2. If necessary, click the Look In list and navigate to the
folder containing the file you want to delete.
3. Right-click on the unwanted file. Do not double-click
the file.
4. Choose Delete from the shortcut menu. (See Figure 1-12.)
A confirmation message appears.
5. Click Yes. Excel deletes the file.
6. Click the Cancel button to close the Open or Save As
dialog box.
Set the Default File Locations
1. Click the Office Button and click Excel Options. (It’s
located at the bottom of the Office list.) The Excel
Options dialog box opens.
2. From the options on the left side of the dialog box,
click the Save category. You see the options shown in
Figure 1-13.
3. In the Default file location, enter the data path to the
place where you want to save most of your files. Click
OK.
By default, Excel saves your files in the My Documents folder stored
on your local hard drive, but your company may have another loca-
tion where it wants you to keep most of your Excel files. An exam-
ple might be G:\COMPANY DOCUMENTS\DIANE
To override the default file location, you can click the Look In list when
saving or opening a file and choose a location different from the default
location.
Figure 1-12: Delete unwanted files through
the Open or Save As dialog box.
Figure 1-13: Customize to determine where Excel stores your workbooks.
➟
12
Chapter 1: Working with Excel Files
05_039212 ch01.qxp 12/29/06 10:42 PM Page 12