Microsoft Office Tutorials and References
In Depth Information
Saving workbooks as web content
Saving workbooks as web content
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 an HTML file. These files, which end with either an
. htm or an . 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 using bold text for the labels. The coding that you use in an HTML file to indicate
that text should be displayed as bold 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 webpage.
You can create HTML files in Excel by displaying the Backstage view, and then clicking Save
As to open the Save As dialog box. To save a workbook as an HTML file, click the Save As
Type arrow, and then click Web Page. In the Save As dialog box, click Entire Workbook,
enter 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 webpage, Excel saves only that worksheet as a webpage.
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 in the Backstage
view to open 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.
Search JabSto ::

Custom Search