Menu
Cart 0

How To View an Excel Workbook as a Web Page

Posted by Roger Hyttinen on

One of the strengths of Excel is the ability to save your worksheets and workbooks as Web Pages that can be accessed via the Web. The Excel document is saved in HTML (Hypertext Markup Language) format, allowing anyone with a Web browser to view the worksheets.

Before saving your document as a Web page, you should preview it in a Web browser to see what it will look like once saved in HTML format. As this feature is not displayed by default on the Excel Ribbon, you will need to add it to the Quick Access Toolbar. Once it has been added, you can click the Web Page Preview button to automatically display the workbook in your default Web browser. The worksheet tabs will appear at the bottom of your screen, allowing you to navigate from one worksheet page to another.

To Add the Web Page Preview Command to the Quick Access Toolbar

  1. Click the drop-down arrow to the right of the Quick Access Toolbar. 
    Quick Access Toolbar Arrow
  2. Select More Commands from the menu.
  3. Select Commands Not in the Ribbon from the Choose Command from: drop-down list. 
    Commands not in ribbon command
  4. Click the Web Page Preview command in the list box and then click the Add button. 
  5. Click OK.

Tip:  You can use this same procedure to add other commands to the Quick Access toolbar.

 

To View a Workbook in Web Page Preview

  1. Click the Web Page Preview button on the Quick Access Toolbar.
  2. Click the sheet tabs at the bottom of the browser window to navigate from one sheet to the next.
  3. Click the browser’s Close button to close the Web browser.

 

Looking for more Excel tips? Check out our new book Excel 2016: Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks


Share this post



← Older Post Newer Post →


Leave a comment

Please note, comments must be approved before they are published.