Page 282 - Excel Workbook for Dummies

29_798452 ch20.qxp 3/13/06 7:44 PM Page 265
Chapter 20: Publishing Spreadsheets as Web Pages 265
Internet Explorer can modify the formatting of the table’s cell entries as well as edit
the contents of their cells. If automatic recalculation is turned on when the interactive
Web page is created, the formulas in the spreadsheet table that refer to those modified
cells are updated as well.

Try It

Exercise 20-2: Creating a Web Page with an Interactive Data Table
Open the workbook Exercise20-2.xls in your Chapter 20 folder in the My Practice
Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
book CD-ROM. This workbook contains a copy of the Home Sales spreadsheet data
table that you will use to practice creating a Web page with an interactive worksheet:

1. Choose File➪Save as Web Page to open the Save As dialog box and there select
the Selection: Sheet option button and the Add Interactivity check box before
you click the Publish button.
Excel then opens the Publish as Web Page dialog box, where you specify the file-
name for the interactive Web page as well as make sure that the page is created
with interactive spreadsheet functionality.
2. Make sure that Items on Home Sales 2006 is selected in the Choose text box, that
Sheet with All Contents of Home Sales is highlighted in the list box below, that
the Add Interactivity check box is selected, and that Spreadsheet Functionality is
selected in the drop-down list box to its right.
3. Select the Browse button to open the Publish As dialog box with the Chapter 20
folder selected and then replace Page.htm with Exercise 20-2.htm (be sure that
you retain the .htm filename extension) before you select OK.
4. In the Publish as Web Page dialog box, select the Open Published Web Page in
Browser check box and then select its Publish button.
After saving the spreadsheet data table in the Exercise20-2.htm Web page,
Internet Explorer opens this new HTML document. In later versions of Internet
Explorer, a security message appears on the Information bar at the top of the
program. The Window and Security alert dialog box then appears. If this hap-
pens, select OK in the alert dialog box. Right-click the Information Bar and click
Allow Blocked Content on the shortcut menu followed by selecting Yes in yet
another Security Warning dialog box. (There now, don’t you feel safe?)
After the Web page opens, note that the interactive spreadsheet data table now
contains a toolbar like the one shown in Figure 20-2.
5. Click the Commands and Options button on the toolbar to open the Commands
and Options dialog box.
This dialog box contains four tabs of options: Format, Formula, Sheet, and
Workbook.
6. Select the cell range B4:D4 in the data table by dragging through their cells and
then click the Italic and Center buttons in the Text Format section of the Format
tab.
The table’s column headings are now centered in their cells and their text is
italicized.
7. Select all the cells in the table (A4:D98) and then click the All button in the
Border section of the Format tab.
All the cells in the data tab are now outlined with a border.
8. Click cell D4 with the Selling Price column heading and then click the Sort
Descending button on the toolbar.