When you create and use a workbook, Microsoft Excel automatically enters information regarding the workbook like size of the file, when the file was created, when the file was modified, where the file is saved, author of the file, was the file printed and many other details. There are other properties that you can set. To do so, perform the following steps:
1. Open the Microsoft Excel workbook.
2. Click File menu. By default the contents in the Info tab section will be displayed. To set the properties, from the right-pane, click Properties button. You will see Show Document Panel, Advanced Properties, and Show All Properties.
You may click on any of the three options to set the properties. Once you had set the properties, you may open Windows Explorer and go the location of the workbook. Now, set the view of the window to Details (Right click on an empty space and hover the mouse over View. Finally click Details). Now, right-click the heading section (Example: Name or Date modified or Type or Size) and click More… to open Choose Details dialog box. From the list, place a check mark to the entries that you set in Microsoft Excel (Example: Tags, Author, Title, etc).
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)