Microsoft Office Tutorials and References
In Depth Information
Saving Workbooks for the Web
With Excel, you can save your workbooks as Web documents, so you and your
colleagues can view workbooks over the Internet or an organization’s intranet. For a
document to be viewable on the Web, it must be saved as a Hypertext Markup Language
(HTML) file. HTML files, which end with either the . htm or the . html extension, include
tags that tell a Web browser such as Windows Internet Explorer how to display the
contents of the file.
For example, you might want to set the data labels in a workbook apart from the rest of
the data by having the labels displayed with bold text. The coding in an HTML file that
indicates text to be displayed as bold text is <b>...</b> , where the ellipsis between the
tags is replaced by the text to be displayed. So the following HTML fragment would be
displayed as Excel in a Web page:
You can create HTML files in Excel by clicking the File tab and clicking Save As to display
the Save As dialog box. To save a workbook as an HTML file, click the Save As Type arrow
and then click Web Page. Then, in the Save As dialog box, select the Entire Workbook
option, type a name for the file in the File Name box, and click Save to have Excel create
an HTML document for each sheet in the workbook.
Tip If the only sheet in your workbook that contains data is the one displayed when you save
the workbook as a Web page, Excel only saves that worksheet as a Web page.
After you save an Excel workbook as a set of HTML documents, you can open it in your
Web browser. To open the Excel file, start Internet Explorer, and then click Open on the File
menu to display the Open dialog box. In the Open dialog box, click the Browse button to
open the Windows Internet Explorer dialog box. You can use the commands in that dialog
box to identify the file you want to open.
When you double-click the file you want to open, the Windows Internet Explorer dialog box
closes and the file’s name and path appear in the Open box. To display the Excel workbook,
click OK, and the workbook appears in Internet Explorer. You can move among the
workbook’s worksheets by clicking the sheet tabs in the lower-left corner of the page.
Saving a workbook to an organization’s intranet site enables you to share data with
your colleagues. For example, Consolidated Messenger’s chief operating officer, Lori
Penor, could save a daily report on package misdeliveries to her team’s intranet so that
everyone could examine what happened, where the problem occurred, and how to ix
the problem. It’s also possible to save a workbook as a Web file that retains a link to the