Page 483 - Excel 2013 All-in-One For Dummies

Preparing a Workbook for Distribution 465
✦ Recover Unsaved Versions to enable you to browse all the versions of the current workbook that were closed without saving the final changes using Excel’s AutoRecover feature (see Book II, Chapter 1 for details)
✦ Delete All Unsaved Versions to enable you to delete various versions of the current workbook that were closed without saving the final changes using Excel’s AutoRecover feature (see Book II, Chapter 1 for details)
At the very bottom of the Info screen, you find a Browser View Options button that, when clicked, opens the Browser View Options dialog box with a Show and Parameters tab. This tab enables you to control what parts
of your workbook are displayed and can be edited when the file is shared online.
Adding properties to a workbook
You can add information about your workbook document (called metadata) in the Info panel in the Backstage view, using the various fields displayed in its right column (refer to Figure 3-1), which you open by selecting File➪Info or pressing Alt+FI. You can then use the metadata that you enter into the Title, Tags, Categories, and Author fields in the Info panel in all the Windows quick searches or file searches you perform. Doing so enables you to quickly locate the file for opening in Excel for further editing and printing or distrib- uting to others to review.
When entering more than one piece of data into a particular field such as Title, Tags, or Categories, separate each piece with a comma. When you’re done adding metadata information to the fields, close the Info panel by click- ing the File menu at the top of the panel or pressing Esc.
Click the Show All Properties link at the bottom of the right column of the Info screen containing the text boxes for particular document properties to add text boxes for additional document metadata fields including Comments, Template, Status, Subject, Hyperlink Base, Company, and Manager.
Digitally signing a document
Excel 2013 enables you to add digital signatures to the workbook files that you send out for review. After checking the spreadsheet and verifying its accuracy and readiness for distribution, you can (assuming that you have the authority within your company) digitally sign the workbook in one of two ways:
✦ Add a visible signature line as a graphic object in the workbook that contains your name, the date of the signing, your title, and, if you have a digital tablet connected to your computer or are running Excel on a touchscreen device, your inked handwritten signature.
Book IV Chapter 3
Sending Workbooks Out for Review