Saving just part of a worksheet
You don't have to save all the data and charts in a particular worksheet in a new HTML file. You can select just the particular data table, cell selection, or embedded chart that you want and save it in the Web page.
The only thing you do differently when you want to save just part of a worksheet is to select the cell range or embedded chart to include before you choose File → Save as Web Page. Then when the Save As dialog box opens, you need to remember to click the Selection option button instead of the Entire Workbook option button before you click the Save or Publish button. If you open the Publish as Web Page dialog box from the Save As dialog box, the Range of Cells option appears in the Choose dropdown list box and the address of the selected range appears in the text box immediately below.
Note that the name of the Selection option changes according to the type of selection you've made in the worksheet:
- When you select a named range to save in the new Web page, Excel displays the name of the range after Selection, as in
- When you select a cell range to save in the new Web page, Excel displays the range address after Selection, as in
- When you select an embedded chart to save as a Web page, Excel changes the option button name to