Page 281 - Excel Workbook for Dummies

29_798452 ch20.qxp 3/13/06 7:44 PM Page 264
264 Part VI: Excel and the Web

Sort Ascending Sort Descending
AutoSum AutoFilter
Paste Refresh All

Copy Export to Microsoft Excel
Cut Commands and Options
Undo Help

Figure 20-2:
Web page
with an
interactive
worksheet
data table
opened in
Internet
Explorer.

The Office Web Components add a horizontal and vertical scroll bar to the interactive
table because you have no way to resize the table. You must use the scroll buttons to
bring new parts of the data table into view on the Web page. Likewise, they automati-
cally display the row and column headers to give you a way to widen or narrow the
columns and heighten or shorten the rows by dragging the appropriate border of a
column letter or row number.

Despite the obvious similarities to the standard workbook window, there are some
noticeable differences as well. Most significant is the fact that the interactive spread-
sheet table has no Formula bar or Menu bar.
Because there’s no Formula bar, you can’t tell which values in the table are calculated
by formula and which are input as constants. It also means that the only way to edit any
of the table cells is by double-clicking the cell and then editing the entry there (at which
time, you can immediately tell whether it’s a value or formula that you’re editing).

Web pages with interactive data tables

When you create interactive Web pages with spreadsheet data tables, users who are
running Microsoft Office Web Components on their computer and view the pages with