Modifying Workbook Properties

If you're not sure when you created or last printed a workbook, or if you need statistical information about a workbook, such as the number of revisions or total editing time, you can use the Properties dialog box to quickly find this information. If you can't remember the name of a range in a workbook, the Properties dialog box keeps track of this information for you. You can also create custom file properties to help you manage and track files. If you associate a file property to an item in the document, the file property updates when you change the item. When you enter information for a property, you can use the Search command on the Tools menu in the Open dialog box or the Advanced File Search task pane to find a workbook with the desired property.

Display Workbook Properties

Open the workbook you want to see properties on. Click the File menu, and then click Properties.

Click the tabs (General, Summary, Statistics, or Contents) to view information about the worksheet:

• General . To find out file location or size.

• Summary . To add title and author information for the document.

• Statistics . To display date related information about a workbook.

• Contents . To display the tab names and the named ranges.

Click OK.

Did You Know?

You can view properties in the Open dialog box . In the Open dialog box, select the file you want to view properties, click the View button, and then click Properties.

Customize Workbook Properties

Click the File menu, and then click Properties.

Click the Custom tab.

Type a name for the custom property or select a name from the list.

Click the data type for the property you want to add.

Type a value for the property that matches the type you selected in the Type box.

Click Add.

Click OK.

Link to Workbook Properties

Name the cell or range in which you want to link the property.

Click the File menu, and then click Properties.

Click the Custom tab.

Type the name for the custom property.

Select the Link To Content check box.

Click the defined content to which you want to link.

Click Add.

Click OK.