If you are looking for how to add tag to Properties in Excel, then you are in the right place. While using Excel we often need to add tag to specify the file properly. Tag in Properties helps the user to deal with the data more efficiently. In this article, we’ll try to discuss how to add tag to Properties in Excel.
Download Practice Workbook
What Are the Document Properties of an Excel Workbook?
Any document contains four types of properties in Excel. Have a look at the below section for those properties.
- Standard Properties:
Those are the common basic properties of a document. Those include title, subject, and author. These properties will help to organize the document according to the creator’s desire.
- Automatically Updated Properties:
The creator of a document can not control to set this property. Those properties will change automatically. Size, modification date, words containing that document, etc. are this kind of property. These properties change automatically.
- Custom Properties:
Those are the additional properties defined by the creator. Those do not default. If the creator then, we will be able to status properties. We will be able to assign text, time, and numeric values in the custom properties.
- Document Library Properties:
Those are the properties related to a document, which can be found in a document library on a website or in a public folder. When we create a new document library, we will be able to define one or more properties in the document library.
2 Easy Steps to Add Tag to Properties in Excel
Excel offers some easy steps to add tags to properties. And these steps are easy to understand and apply.
1. Finding the Properties
We need to first find the Properties in Excel to find the Tag box and subsequently add Tag.
- Firstly, open the Excel file.
- Secondly, go to File.
- Thirdly, select Info.
- Eventually, we’ll see the Properties box on the right side of the window.
2. Adding Tag to Properties
After finding Properties, we need to add a Tag. In the following figure, we can see that the Tag box is under Properties.
- So, click on the Tag.
- Eventually, the editing mode will appear.
- Secondly, add any Tag in the Tag In this case, it is Adding Tag to Properties.
- Thirdly, click anywhere outside of the Tag
- Consequently, the Tag is added like this.
Things to Remember
- If we want to edit the Tag, just click on the Tag box again, and the editing mode will appear.
- Additionally, when we need to delete Tag, just click on the Tag box, select the writing on the box, and press DELETE or BACKSPACE.
That’s all about today’s session. And these are the ways to add Tag to Properties in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section and explore our website ExcelDemy, a one-stop Excel solution provider.