How to Move or Copy Excel 2007 Worksheets to Other Workbooks
Comparing Two Excel 2007 Worksheets Side by Side
Excel 2010 Data-Entry Etiquette

Specifying Workbook Properties in Excel 2007

In Microsoft Office Excel 2007, you can use the new Document Information Panel to add or change workbook properties such as the Author, Title, Keywords, Status, and Comments that relate to a specific workbook. Adding metadata such as this can help you to better identify and manage your workbook files.

1

Click the Office Button and point to Prepare.

A list of options appears in the right panel.

2

Click Properties.

The Document Information Panel appears below the Ribbon.

3

Enter identifying information such as the author’s name, subject, or a list of keywords.

The information you enter here can be used with the Search function to help find a workbook.

4

Click the Close button to close the Document Information Panel.

The Close button is located in the upper-right corner of the Document Information Panel.

If you want to add more properties using the Properties dialog box, you can click the Document Properties button (at the top left corner of the Document Information Panel) and select Advanced Properties. Excel automatically adds statistical information here, such as the workbook’s original creation date, the last time it was printed or modified, and the workbook size.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Arranging Windows in Excel 2007 Workbooks
Fixing Broken Formula Links in Excel 2007
Document Recovery in Excel 2007
How to Protect an Excel 2007 Workbook
Dealing with the New Excel 2007 File Formats
Advertisement

Inside Dummies.com