Use any of the regular document property names, including Use this formula to add a property to the worksheet: =docprop('Author') Private Function DocProp(Info_needed As String) As VariantĭocProp = ThisWorkbook.BuiltinDocumentProperties(Info_needed).Value We found this one here from ‘Jon-jon’, thanks. In Excel, the only way to add document properties into a worksheet is via a custom function. Go to File | Info in Excel 2013 (Prepare | Properties in Excel 2007) and all the properties are there including a document panel, advanced and custom properties, same as in Word. You can add and edit document properties in worksheets much the same as in Word documents. We also complained about the poor support for properties in Excel. Tip courtesy of How-To Geek.We’ve already told you about document properties and how useful they are in Word.

To close the panel, click the “X” button in the upper-right corner of the panel. You can also use the “Document Properties” button on the panel to access the properties dialog you can also use to edit the properties and view other information. For each property, there’s an edit box displaying the current value for the property and allowing you to change the values.

You are automatically returned to your document where the “Document Information Panel” displays below the ribbon. To show the panel, click “Properties” on the “Info” screen and select “Show Document Panel.” You can also display and change the advanced properties in a “Document Information Panel” above the document. The keywords you entered are displayed as “Tags.” You are returned to the “Info” screen and the advanced properties you entered display. To access the properties you can change, click the “Summary” tab.Įnter properties on the “Summary” tab such as “Title,” “Author,” “Company,” and “Keywords.” Keywords are also called tags and can be used to categorize and find your document more easily. On the right side of the “Info” screen, click “Properties” and select “Advanced Properties” from the drop-down list.Ī dialog box displays with the file name (without the file extension) on the title bar, showing you information about your document. If not, click “Info” at the top of the list of items on the left. To access the dialog box that allows you to change the properties for the currently open document, click the “File” tab.īy default, the “Info” screen should display. Microsoft Office 2013 was used in this demonstration. Some of these properties are displayed on the “Info” screen and you can change these properties. Microsoft Word allows a user to store several types of advanced properties related to your document.

Document properties word title