Microsoft Office Tutorials and References
In Depth Information
To create a static Web page, you follow these general steps:
Open the workbook with the data to be saved as a Web page.
Click the File menu and select the Save as Web Page option, as shown in Figure 25-1.
Figure 25-1. The Save as Web Page dialog box is similar to the Save dialog box
with several enhancements for Web page functionality.
Tip Select What to Save
If you know that you want to save a particular chart or particular range of cells of a
worksheet in the new Web page, you should select the chart to be saved before you open the
Save As dialog box. By selecting a particular chart or a range of cells, you will be able to
save only the required information to your Web page. Selecting the chart ahead of time
changes the Selection: Sheet option button to the Selection: Chart option button. In the
case of a cell range selection, the Selection: Sheet option button changes to a Selection:
option button, followed by the address of the cells selected.
Specify the location where the Web page is to be saved.
Indicate which part of the workbook is to be saved in the new Web page. To save the
contents of all sheets in the workbook, make sure that the Entire Workbook option
button is selected. To save only the data in the current worksheet, choose the Selection:
Sheet option button instead. Remember, if you clicked the chart in the worksheet that
you intend to convert into a Web page graphic before opening the Save As dialog box,
you need to choose the Selection: Chart option button, which replaces the Selection:
Sheet button. If you selected a cell range, you need to choose the Selection: option
button, followed by the address of the selected cell range. If you want to save the contents
of a worksheet other than the one currently selected, you can specify this later.
Type the name for the new Web page in the File Name text box.