Microsoft Office Tutorials and References
In Depth Information
Previewing and Printing a Workbook
Previewing and Printing a Workbook
Now that you have fi nished the fi nal edit of the workbook, you are ready to print a hard
copy of the customer orders list for Amanda. However, before you print the workbook,
you should preview it to ensure that it will print correctly.
Changing Worksheet Views
You can view a worksheet in three ways. Normal view , which you’ve been using
throughout this tutorial, shows the contents of the worksheet. Page Layout view shows
how the worksheet will appear when printed. Page Break Preview displays the location
of the different page breaks within the worksheet. This is useful when a worksheet will
span several printed pages and you need to control what content appears on each page.
You’ll switch between these views to see how the Customer Orders worksheet will
appear on printed pages.
To view the workbook
in the full screen space,
which hides the Ribbon,
click the Full Screen
button in the Workbook Views
group on the View tab.
Press the Esc key to exit
the view.
To switch the worksheet views:
1. Click the Page Layout button on the status bar. The page layout of the
worksheet appears in the program window. You want to see the rest of the data, which
extends to a second page.
2. Use the Zoom slider to reduce the zoom level to 60% . See Figure 1-28.
Figure 1-28
Worksheet displayed in Page Layout view
worksheet will
span two pages
Page Layout
butto n
3. Click the Page Break Preview button on the status bar. The view switches to
Page Break Preview, which shows only those parts of the current worksheet that
will print. A dotted blue border separates one page from another.
Trouble? If the Welcome to Page Break Preview dialog box opens, this is the first
time you’ve switched to Page Break Preview. Click the OK button to close the
dialog box and continue with Step 4.
Search JabSto ::

Custom Search