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

512 Exporting Workbooks to Other Usable File Formats
8. Select the Open Published Web Page in Browser check box and then
click the Publish button.
When you click the Publish button, Excel closes the Publish As Web Page dialog box, saves the spreadsheet as an HTML file, and then immediately launches your default web browsing program while at the same time opening the new HTML file in the browser. After you finish looking over the new HTML file in your web browser, click its program window’s Close button to close the browser and HTML file and to return to Excel and the original worksheet.
Keep in mind that you can control which worksheets and named ranges (see Book III, Chapter 1 for details) appear when a workbook is viewed in a web browser in the Browser View Options dialog box opened by choosing File➪Export➪Browser View Options and then clicking the Browser View Options button (Alt+FEBA).
If you add the Web Page Preview and Web Options commands as custom buttons to the Quick Access toolbar, you can use them to preview how a worksheet will appear as a web page locally in your web browser as well
as control a whole variety of web page save options. To add these buttons, open the Customize the Quick Access Toolbar tab of the Excel Options dialog box (Alt+FTQ) and then add the Web Page Preview and Web Options from Commands Not in the Ribbon section. (See Book I, Chapter 2 for details.)