Datasheet

Specify Workbook Properties
1. Choose File➪Properties. The Properties dialog box
appears with several tabs:
• General: Illustrates filename, location, size, and dates
including the creation, modification, and last accessed
date. Excel automatically updates the information on
the General tab.
• Summary: Includes fields for author, title, subject,
and other similar information. (See Figure 1-11.)
• Custom: Allows you to create custom fields that you
can assign text, date, number, or even yes or no values
(see Figure 1-12).
• Statistics: Displays facts about the workbook usage
including creation, modification and last print date,
editing time, and revision numbers.
• Contents: Displays a list of all worksheets included
in the workbook.
To have Excel automatically prompt you to set file properties for
every workbook you create, choose Tools➪Options and on the
General tab, select the Prompt for Workbook Properties check box.
When you save a workbook the first time, Excel displays the
Properties dialog box.
2.
Select the tab on which you want to enter information
and enter any desired data.
3. Click OK.
4. Save the workbook. The workbook properties are saved
with the workbook data.
Figure 1-11: Search for workbooks based on information stored in the Properties
dialog box
Figure 1-12: Create your own summary fields
➟
11
Specify Workbook Properties
05_574884 ch01.qxp 3/7/06 9:57 PM Page 11