Page 283 - Excel Workbook for Dummies

29_798452 ch20.qxp 3/13/06 7:44 PM Page 266
266 Part VI: Excel and the Web
All the cells in the table are now sorted by selling price from highest to lowest.
9. Click the Sheet tab in the Commands and Options dialog box and then click the
Row Headers, Column Headers, and Gridlines check box to remove their check
marks.
The column and row headings as well as the worksheet gridlines are now
removed from the spreadsheet data table.
10. Click the Workbook tab in the Commands and Options dialog box and then click
the Sheet Selector check box to remove its check mark.
The Home Sales 2006 sheet tab is now removed from the spreadsheet data table.
11. Select the Manual option button in the Calculation section on the Workbook tab
and then double-click the cell with the selling price of 422 Apple Drive in the
table and replace its current 645000 entry with 750000 before you press the
Enter key.
12. Select the Calculate button in the Calculation section on the Workbook tab.
The Web Components now update the Average price, High price, Low price, and
Median price cells in the interactive spreadsheet data table.
13. Select the Toolbar check box in the Show/Hide section of the Workbook tab to
remove its check mark and then click the Close button in the upper-right corner
of the Commands and Options dialog box to close it.
The interactive toolbar now disappears from the spreadsheet data table.
Note that you can always restore the toolbar by right-clicking any cell in the
interactive spreadsheet data table and then selecting Commands and Options on
its shortcut menu to reopen the Commands and Options dialog box. From there,
you can then reselect the Toolbar check box on the Workbook tab.
14. Choose the File➪Print Preview Internet Explorer menu command to display the
interactive spreadsheet data table in the Print Preview window.
15. If you have access to a printer, click the Print button on the Print Preview toolbar
to print the Web page. Otherwise, click the Close button to return to the regular
Web page without printing the page.
16. Close the Internet Explorer and then close the Exercise20-2.xls workbook in Excel
without saving any changes to it.

Web pages with interactive data lists

When you create interactive Web pages with data lists, your users can sort and filter
the data in the list as well as modify individual entries in the records and make format-
ting changes to parts of the list. To filter the data in the Web, users turn on AutoFilter
drop-down buttons that work just like those in a regular Excel data list (see Chapter 16).

Try It

Exercise 20-3: Creating a Web Page with an Interactive Data List
Open the workbook Exercise20-3.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 Employee data list that you can
use to practice creating a Web page with an interactive data list:

1. Choose File➪Save as Web Page to open the Save As dialog box. Select the
Selection: Sheet option button and the Add Interactivity check box before you
select the Publish button.