Finding files can be difficult on computers you share with your colleagues or if you’ve been using the same computer for a long time and have created a lot of workbooks. You can make it easier to find your files by describing them in the Properties. If you enter a term in a Properties field, you will be able to search using that term, even if it doesn’t occur within the body of the workbook.
Set File Properties
Open the file to which you want to assign property values.
Click the Microsoft Office button.
Point to Prepare.
Click Properties.
Add information describing your file.
Tip
Adding words to the Keywords field is a great way to improve search results. Just type a word, press the space bar, and then type the next word. There’s no need to use commas.
Define Custom Properties
Open the file for which you want to assign property values.
Click the Microsoft Office button.
Point to Prepare.
Click Properties.
Click the Document Properties down arrow.
Click Advanced Properties.
Click the Custom tab.
Select a property name.
Select the type of data contained in the property.
Type a value for the property.
Click Add.
Click OK.
Tip
Excel comes with a set of predefined custom properties such as Checked By and Date Completed. If one of the existing properties fits your needs, feel free to use it.