You may need to update the author name, document title, or keywords for a shared Excel file. Workbook properties are metadata stored within the file that help identify and organize it. This article explains how to access and edit these details directly within Excel.
Key Takeaways: Editing Workbook Properties
- File > Info > Properties: Opens the main panel to edit the most common details like author, title, and tags.
- Show Document Panel: Displays a persistent editing bar at the top of your worksheet for quick changes.
- Advanced Properties dialog: Provides access to custom properties, revision statistics, and more technical metadata.
Understanding Excel Workbook Properties
Workbook properties, also called metadata, are descriptive details attached to an Excel file. They are separate from the cell data and formulas inside your worksheets. Common properties include the author’s name, document title, subject, keywords or tags, and comments. These details are useful for searching and filtering files in Windows File Explorer or SharePoint. They also appear in the document’s print preview and can be inserted into headers or footers.
Excel stores two main types of properties. Standard properties have predefined names like Author and Title. Custom properties are user-defined name-value pairs you can create for specific tracking needs. Before editing, ensure you have permission to save changes to the file. Editing properties does not alter the worksheet data, but you must save the workbook to keep the new metadata.
Steps to Edit Standard Workbook Properties
The simplest method is to use the Info panel in the Excel backstage view. This is best for changing the core details like author, title, and tags.
- Open the workbook and go to the File tab
Click File in the top-left corner of the Excel window. This opens the backstage view. - Select the Info category
On the left sidebar, click Info. The right panel will show information about the current workbook. - Click on the Properties dropdown
On the right side, find the Properties heading. Click the small downward arrow next to it and select Advanced Properties. For quick edits, you can also click directly on text fields like Author or Title shown in the panel. - Edit details in the Summary tab
In the Properties dialog box, go to the Summary tab. Here you can edit the Author, Title, Subject, Keywords (tags), Category, Status, and Comments. Type your changes directly into the fields. - Save the workbook
Click OK to close the dialog. You must save the workbook by clicking Save on the File tab or pressing Ctrl+S for the new properties to be stored permanently.
Using the Document Panel for Quick Edits
For frequent editing, you can display a persistent panel within the worksheet window.
- Open the File tab and select Info
Navigate to File > Info as in the previous method. - Open the Properties dropdown
Click the arrow next to Properties in the Info panel. - Select Show Document Panel
Choose this option from the menu. A gray bar will appear at the top of your worksheet, below the ribbon. - Edit properties directly in the panel
Click into the Author, Title, Keywords, or other fields in the Document Panel and type your changes. The updates are applied as you type. - Close the panel when finished
Click the X at the far right of the Document Panel to hide it. Remember to save your workbook.
Common Mistakes and Limitations
Properties Are Not Saving After Editing
If your changes revert, the workbook might be open in Read-Only mode or stored in a protected location. Check the file name in the title bar for [Read-Only]. Save a copy of the file to a different folder with Save As, then edit the properties of the new copy. Also, ensure you have write permissions for the original file location.
Author Name Updates for All New Files
Changing the author for one file does not change the default user name Excel uses for new files. To set a permanent default author, go to File > Options > General. Under Personalize your copy of Microsoft Office, change the User name field. This name will be used as the author for all new workbooks you create.
Tags or Keywords Not Working in File Explorer Search
Windows File Explorer indexing may take time to update. Ensure you have saved and closed the Excel file. The Keywords property in Excel maps to the Tags field in Windows. If search still fails, rebuild the Windows search index via Settings > Search > Searching Windows.
Standard Properties vs. Advanced Properties
| Item | Standard Properties | Advanced Properties |
|---|---|---|
| Access Method | File > Info panel or Document Panel | File > Info > Properties > Advanced Properties |
| Common Fields | Author, Title, Tags, Subject, Comments | All standard fields plus Statistics, Custom, Content tabs |
| Primary Use | Quick editing of basic identifying metadata | Viewing statistics, creating custom properties, technical details |
| Customization | Cannot add new field names | Can define new custom property names and values |
| Automatic Data | Mostly manual entry | Statistics tab shows system-generated data like edit time |
You can now accurately update the author, title, and tags for any Excel workbook. Use the Document Panel for quick edits while working on a file. For a deeper look, explore the Advanced Properties dialog to add custom fields for project tracking. Try inserting a property, like the file title, into your header via Insert > Header & Footer > Header > Design > Document Info.