• Go Ask Debbie

Excel Properties

Have you ever sent an Excel spreadsheet to someone whom asks you details on when the worksheet was created or other details?

Well, this tip shows you how to add some basic contact and worksheet information for yourself and others. Excel Properties allows users to search for spreadsheets and access some other details of the file including the Author, Company, and like information. Excel 2007 allows "Comments" to be added for further reference and details.

To add information to the Excel Properties, follow these steps.

Click on the "Office Button," hover to "Prepare," and click on the "Properties" option.

HINT: For Excel 2003 and earlier (and for 2010), click on the "File" Menu/Tab and select "Properties."

In Excel 2007 and 2010, the "Properties" window opens above the worksheet fields.

Information such as phone number, email, formulas, or other information may be added for reference.

In Excel 2003 and earlier, the "Properties" window opens as a pop-up window.

Notice that the "Properties" window prefills the "Author" field as the user of the said computer.

In Excel 2007 and 2010, click on the "Document Properties" drop-down and select "Advanced Properties" to add further information.

This window appears similar to Excel 2003 and earlier versions.

If this window is chosen, you will need to click on the "OK" button when completed.

Simply save the workbook and the added information is saved with the workbook.

When sending Excel spreadsheets to others, this information is stored for their reference.


Recent Posts

See All