To save an Excel workbook as a web page, open the workbook that you want to create a web page from, and choose File->Save As Web Page from the menu bar to invoke the save as dialogue box.

 

 

In the Save in text field, specify the location where you want to save your file, then select Web Page (*.htm; *.html) from the Save as type drop list at the bottom. Next, make sure the Entire Workbook radio button is selected, and put a checkmark in the Add interactivity box if you want an interactive web page. When you are finished, click the Save button to save the workbook as a web page.

 

Alternatively, select the location you want to save to, and specify Web Page (*.htm; *.html) as the file type. Then click the Publish button to display the Publish as Web Page dialogue box.

 

Select entire workbook from the Choose: drop list, and click Publish to save the file as an html web page.

 

 

 

This is a workbook saved as an interactive web page. You should notice that you can select individual worksheets in the workbook from the tab at the lower left.