Microsoft Office Tutorials and References
In Depth Information
Documenting Workbook Properties
Documenting Workbook Properties
Excel automatically documents workbook properties while you work, such as file size,
save dates, and various statistics, and allows you to document other properties, such as
title, author, subject, keywords, category, and status. You can view or edit standard doc-
ument properties or create advanced custom properties by using the Document Inform-
ation Panel , which is actually an XML-based Microsoft InfoPath 2013 form hosted in
Excel. You can use document properties—also known as metadata—to help you manage
and track files; search tools can use the metadata to find a workbook based-on your search
criteria. If you associate a document property to an item in the document, the document
property updates when you change the item.
View and Edit Document Properties
Click the File tab, and then click Info .
To display other properties, click the Properties button, and then select an op-
tion:
Show Document Panel. Shows Document panel in the workbook.
Advanced Properties. Displays the Properties dialog box.
Search JabSto ::




Custom Search