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

510 Exporting Workbooks to Other Usable File Formats
After choosing XPS Document as the file type, if you don’t need to edit the filename (Excel automatically appends .xps to the current filename) or the folder location, simply click the Save button (in the Save As dialog box) or Publish button (in the Publish as PDF or XPS dialog box), and Excel saves the workbook in an XPS file.
If you want Excel to automatically open the new XPS file for your inspection in Internet Explorer or the XML Paper Specification Viewer, make sure that the Open File after Publishing check box is selected before you click the Publish button.
By default, the Standard (Publishing Online and Printing) option button is selected in the Optimize For section at the bottom of the Publish as PDF
or XPS dialog box. If you want to make your XPS file version of the spread- sheet smaller for viewing online, click the Minimum Size (Publishing Online) option button before you click the Publish button. Also, if you need to restrict which parts of the current workbook are included in the new XPS file or don’t want nonprinting information included in the resulting file, open the Options dialog box by clicking the Options button and select the part of the workbook or worksheet to publish and choose which nonprinting informa- tion to omit from the resulting XPS file.
Saving worksheets as HTML files
If converting your worksheets to PDF or XPS files is way too complex for your needs, you can save your worksheets as good old HTML files for viewing and printing in anybody’s web browser (as well as for publishing to your website). To save
1. Choose File➪Save As or press Alt+FA to open the Save As screen in the Backstage view.
Here you select the place into which to save the HTML file.
2. Select the drive and folder where you want the web version of the workbook saved.
Excel opens the Save As dialog box with the drive and folder you just designated open and selected.
3. Choose Single File Web Page or Web Page from the Save as Type drop-down menu.
Select Single File Web Page as the file type when your workbook only has one worksheet or you want the data on all the worksheets to appear on a single page. Select Web Page when you want to each worksheet in the workbook to appear on sequential web pages.
When you select either web page option, Excel expands the Save As dialog box to include the Entire Workbook (selected by default) and