Microsoft Office Tutorials and References
In Depth Information
HTML The Hypertext Markup Language (HTML) is the standard markup language used for docu
ments on the World Wide Web. HTML uses tags to indicate how Web browsers should display
page elements such as text and graphics and how to respond to user actions.
The concept of publishing Excel spreadsheet data on the World Wide Web makes a lot of
sense, both from the standpoint of the worksheet’s tabular layout and the worksheet’s calcu
lated contents. Anyone who has coded an HTML table can tell you that this is a tedious task.
Even creating the simplest HTML table is time consuming because you have to use <TH>
and </TH> tags to set up the column headings in the table, along with <TR> and </TR> tags
to set up the rows of the table, and <TD> and </TD> tags to define the number and width of
the columns, as well as what data goes in each cell of the table.
Saving a Worksheet as a Web Page
Saving a Worksheet as a Web page is a simple task in Excel. You can set up your worksheet
with the appropriate data, charts, and PivotTables. Once the setup is complete, you can save
your worksheet as a Web page.
Excel enables you to create Web pages that display your worksheet data either in a static,
“look but do not touch” mode, or in an interactive, “have some fun” mode. When you create
a Web page with static worksheet data, your users can view the Excel data only with their Web
browsers. However, when you create a Web page with interactive worksheet data, your users
can continue to play around with the data by editing and formatting its values. Depending
upon the nature of the spreadsheet, your users can even continue to perform calculations
and, in cases of data lists, manipulate the data by sorting and filtering it.
There are many considerations before you save your workbook or worksheet as a Web page.
For example, you’ll need to decide if you plan to save a portion of a workbook or a part of a
worksheet. When you decide to save a part of a worksheet, you should select the cells before
you start the save process. You aren’t limited to saving a range of cells—you can save a chart
as a Web page, as well.
When choosing the location to place the Web page, you should consider whether it will be
stored on your local hard drive or network drive, or whether you want to post the Web page
directly on your company’s Internet or intranet Web site. To save the new page on a File
Transfer Protocol (FTP) site, select FTP Locations from the Save In drop-down list box and
then open the FTP folder in which you want the page saved. The Web folders or FTP loca
tions must be set up before you can save your worksheet Web pages to these locations. You
can also add a title, which appears centered at the top of the page before any of the data or
charts. This isn’t the only time you can specify your Web page title; you can add or edit the
Web page title after the page is created.