To create a webpage from a single worksheet, open the Excel workbook that contains the sheet you want to use, and choose File->Save As Web Page from the menu bar.

 

 

In the save as dialogue box, specify Web Page (*.htm; *.html) in the Save as type drop list.

 

Make sure that the location that you want to save the web page in is chosen in the Save in drop list at the top of the dialogue box, and be sure to select the Selection: Sheet radio button. Put a checkmark in the Add interactivity checkbox if you wish, and click the Save button to create the html file.

 

Alternatively, you can specify Web Page (*.htm; *.html) as the file type, choose a location to save the file in, select the Selection: Sheet radio button, and click the Publish button.

 

 

In the Publish as Web Page box, check the Add interactivity with checkbox, (if you want an interactive webpage) and select either spreadsheet functionality (edit formulas and cell entries), or PivotTable functionality, (pivot and filter data). Click the Publish button to create the web page.

 

 

This worksheet was saved as an interactive web page with PivotTable functionality.

 

The button indicated by the arrow activates the PivotTable field list.