Save a workbook as a Web page
You can save a whole workbook, including tabs to move between sheets, to a Web page. Or you can save parts of a workbook, such as a sheet, a range or a chart, to a Web page. On the Web, your Excel data can be viewed but not changed.
|Note When you save an Excel workbook as a Web page, you can open the resulting file in Excel, make changes, and save the file. However, fewer Excel features are maintained in the file, and you might be unable to change them as you could originally. For best results, we recommend that you use the original workbook (*.xlsx) as your "master" copy that you open, make changes, save as a workbook, and then save as a Web page.|
Open or select the workbook that contains the data that you want to publish.
To save only part of the data on a sheet as a Web page, select the data that you want to save.
On the File menu, click Save as Web Page.
Use the column browserA mechanism used in Mac OS X to locate and select folders and files. Scroll left or right to move through the folder hierarchy.
If the column browser is hidden, click the arrow next to the Save As or Where pop-up menu. to find the folder that you want, and then double-click the folder.
In the Save As box, type a name for the document.
Do one of the following:
Each sheet in the workbook
The selected sheet
The selected data on the sheet
Click Web Options, and then click each tab to select the options that you want for the Web page.
For example, you can type the title for the Web page, add search keywords, control when links are updated, control the format and resolution of pictures, and change the character encoding to another language.
Click OK and then click Save.
Note To save data to a Web page on an automatic schedule, click Automate.