Microsoft Office Tutorials and References
In Depth Information
Overview
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 Offi ce applications, refer to Appendix D.
This Web feature illustrates how to create and save the Web pages on a USB fl 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
Locations
You can save any type
of fi 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
particularly useful
because they appear
as standard folders in
Windows Explorer or in
the Address bar list. For
additional information,
see Appendix D.
Overview
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 fi 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.
1
Connect a USB fl ash drive with
the Data Files for Students on it to
one of the computer’s USB ports.
Customize Quick
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.
Customize Quick
Access Toolbar menu
2
Click the Customize Quick Access
Toolbar button to display the
Customize Quick Access Toolbar
menu (Figure 2).
More Commands
command
 
 
Search JabSto ::




Custom Search