Microsoft Office Tutorials and References
In Depth Information
Excel Web Feature Creating Web Pages Using Excel
Saving Workbooks as Web Pages
The Save As dialog box changes when you select Single File Web Page, which is
in MHTML format, in the ‘Save as type’ box. When you use the Single File Web Page
format, a Save area appears in the dialog box. Within the Save area are two option
buttons and a Publish button (Figure 11). You can select only one of the option buttons. The
Entire Workbook option button is selected by default. This indicates Excel will save all
the active sheets (1st Quarter Sales and 3-D Pie Chart) in the workbook as a Web page.
The alternative is the Selection: Sheet option button. If you select this option, Excel will
save only the active sheet (the one that currently is displaying in the Excel window) in the
workbook. The Publish button in the Save As dialog box in Figure 11 is an alternative to
the Save button. It allows you to customize the Web page further.
If you have access to a Web server and it allows you to save ﬁ les in a Web folder,
then you can save the Web page directly on the Web server by clicking the My Network
Places button in the Save in bar of the Save As dialog box (Figure 11). If you have access
to a Web server that allows you to save on an FTP site, then you can select the FTP site
below FTP locations in the Save in box just as you select any folder in which to save a ﬁ le.
To learn more about publishing Web pages in a Web folder or on an FTP location using
Ofﬁ ce applications, refer to Appendix D.
After Excel saves the workbook in Step 4, it displays the MHTML ﬁ le in the Excel
window. Excel can continue to display the workbook in HTML format, because, within
the MHTML ﬁ le that it created, it also saved the Excel formats that allow it to display the
MHTML ﬁ le in Excel.
You can add hyperlinks
to an Excel workbook
before you save it as a
Web page. The hyperlinks
in the Excel workbook
can link to a Web page, a
location in a Web page,
or an e-mail address that
automatically starts the
viewer’s e-mail program.
To Reset the Quick Access Toolbar and Quit Excel
Viewing Source Code
To view the HTML source
code for a Web page
created in Excel, use your
browser to display the
Web page, click View on
the menu bar, and then
The necessary work with the Excel workbook is complete. The following steps
remove the Web Page Preview button from the Quick Access Toolbar and quit Excel.
1 Click the Customize the Quick Access Toolbar button on the Ribbon.
2 Click the More Commands command.
3 When the Excel Options dialog box is displayed, click the Reset button. If the Reset
Customizations dialog box is displayed, click the Yes button.
4 Click the OK button in the Excel Options dialog box to close it.
5 Click the Close button on the Microsoft Excel title bar.
Do I need to remove the button from the Quick Access Toolbar?
No. For consistency, in this topic the Quick Access Toolbar is reset after the added buttons
no longer are needed. If you share a computer with others, you should reset the Quick Access
Toolbar when you are ﬁ nished using the computer.