Microsoft Office Tutorials and References
In Depth Information
Excel Web Feature Creating Web Pages Using Excel
company’s intranet. If you have access to a Web server, you can publish Web pages by saving
them on a Web server or on an FTP location. To learn more about publishing Web pages on a
Web server or on an FTP location using Microsoft Ofﬁ ce applications, refer to Appendix D.
This Web feature illustrates how to create and save the Web pages on a USB ﬂ ash drive,
rather than on a Web server. This feature also demonstrates how to preview a workbook as a
Web page and create a new folder using the Save As dialog box.
Web Folders and FTP
You can save any type
of ﬁ le to a Web folder
or on an FTP location,
just as you would save
to a folder on your
hard disk. Web folders
and FTP locations are
because they appear
as standard folders in
Windows Explorer or
in the Save in list. For
see Appendix D.
As you read through this Web feature, you will learn how to create the worksheet shown
in Figure 1 on pages EX 250 and 251 by performing these general tasks:
• Save a Workbook as a Web page
• Preview the Workbook in a Web browser
• Complete ﬁ le management tasks within Excel
Using Web Page Preview and Saving an Excel
Workbook as a Web Page
At any time during the construction of a workbook, you can preview it as a Web page by
using the Web Page Preview command. The Web Page Preview command is not available
on the Ribbon, but you can add the command to the Quick Access Toolbar. When you
invoke the Web Page Preview command, it starts your browser and displays the active
sheet in the workbook as a Web page. If the preview is acceptable, then you can save the
workbook as a Web page.
To Add a Button to the Quick Access Toolbar
Many commands available in Excel are not included on any of the tabs on the Ribbon. You can, however,
add such commands to the Quick Access Toolbar. One such command allows you to preview a document in a Web
browser. This command, Web Page Preview, needs to be added to the Quick Access Toolbar so that the Web page
can be previewed. The following steps add the Web Page Preview command to the Quick Access Toolbar.
• Connect a USB ﬂ ash drive with
the Data Files for Students on it to
one of the computer’s USB ports.
Access Toolbar button
COMP: Make sure arrows
are pointing precisely where
the Art MS indicates - they
cannot even be slightly off
• Start Excel and then open the
workbook, Stonegate Plumbing
1st Quarter Sales, from the Data
Files for students.
Access Toolbar menu
• Click the Customize Quick Access
Toolbar button to display the
Customize Quick Access Toolbar
menu (Figure 2).