If you want to select individual worksheets or items to publish in the workbook, click the Publish Options button. Otherwise, if you want to publish the entire workbook, skip directly to step 4.
On the Show tab, do the following:
To show the entire workbook in the browser, select Entire Workbook in the list box.
To show only specific worksheets in the browser, select Sheets in the list box, and then clear the check boxes for the sheets that you do not want to make visible.
Note By default, all sheets are selected. To quickly make all sheets viewable again after you clear some of the check boxes, you can select the All Sheets check box.
To show only specific items in the browser (such as named ranges, charts, tables, or PivotTables), select Items in the Workbook in the list box, and then select the check boxes of the items that you want to show.
Note If you select items that have the same name (such as a chart and its underlying table of data), only one of these items will be available in the browser. To show all the items, you must make sure that each item in the workbook has a unique name. You can rename tables on the Design tab in the Properties group, rename PivotTables on the Options tab in the PivotTable group, and rename charts or PivotCharts on the Layout tab in the Properties group. Duplicate items, such as named ranges, can be renamed on the Formulas tab in the Defined Names group.