Using Web Page Preview in Excel 2007

by rhyttinen on July 24, 2009

One of the strengths of Excel 2007 is the ability to save your worksheets and workbooks as Web Pages that can be accessed via the World Wide 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 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.

Web Page Preview in Excel 2007

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.
  2. Select More Commands from the menu.
  3. Select Commands Not in the Ribbon from the Choose Command from: drop-down list.
  4. Click the Web Page Preview command in the list box and then click the Add button.
  5. Click OK.

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.

Similar Posts:

Share and Enjoy:
  • del.icio.us
  • Digg
  • TwitThis
  • Reddit
  • Technorati
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • Propeller
  • E-mail this story to a friend!

Leave a Comment

Previous post: Editing and Deleting Comments in Excel 2007

Next post: Using Relative References in Excel