Excel 2013 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

The Info screen in the Excel 2013 Backstage view (Alt+FI) enables you to prepare your workbook for distribution by inspecting the properties of your workbook. To do this, click the Check for Issues button in the Info screen and then select any of the following options:

  • Inspect Document to open the Document Inspector, which checks your documents for hidden content and metadata (data about the document). You can delete any such content that you find prior to distributing the file by clicking the Remove All button.

  • Check Accessibility to have Excel scan the workbook file for information that people with disabilities (particularly, some sort of sight impairment) might have difficulty with.

  • Check Compatibility to check a workbook file saved with the default Excel Workbook (*.xlsx) XML file format option for any loss in fidelity when it’s saved in the older Excel 97-2003 Workbook (*.xls) binary file format.

    image0.jpg

Below the Check for Issues button, the Info screen contains a Versions button that, when clicked, gives you the following two options for recovering or clearing up draft versions of the workbook so that only the final version is available for sharing:

  • 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

  • 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

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.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

This article can be found in the category: