Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Prepare Excel 2013 Workbooks for Distribution

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.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!