Specifying Workbook Properties in Excel 2010

Excel Sales Forecasting For Dummies

In Excel 2010, you can use the 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.

Click the File tab, and from the Info panel, choose Properties.

A list of options appears in the right panel.

Choose Show Document Panel.

The workbook reappears, and the Document Information Panel appears just below the Ribbon.

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.

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.

About This Article

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988 that services the central Indiana area. Her are of expertise h as long been in the word processing, spreadsheet, and graphics area of computing as well as in providing training and support for Peachtree Accounting Software. Diane's authoring experience includes more than 30 books on topics such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of her books have been translated into other languages such as Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.