Here are some steps on how to set the workbook properties for every Workbook you create in Microsoft Excel 2010.
Workbook Properties in Microsoft Excel can help you to find your workbook more easily and to see who the author was. You can also see when the workbook was last saved and how long it was worked on.
To set the Workbook properties:
- Go to the File tab on the Ribbon
- Go to Info
- Go to the Properties area on the far right of the screen
- Click into the Properties fields (1) to set the properties