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 document properties or create advanced custom properties by using the Document Information 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 ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.