Microsoft Office Tutorials and References
In Depth Information
Handling Special Printing Needs
Changing Orientation in
the Same Print Job
As you discovered in Chapter 9, “Preparing to
Print,” orientation refers to the direction of the
printed page. Excel will print your file in portrait
(vertical) or landscape (horizontal) format. By
default, Excel will print all of the pages in a
workbook using the same page orientation.
However, you can use the features provided
in Excel to customize the orientation to fit
You can specify the print orientation for
each worksheet in a print job.
You can specify the print orientation for each
worksheet in a workbook file.
Printing Multiple Pages
on a Single Sheet
Excel worksheets are created to manage your
data. They are generally formatted to serve that
purpose, and not necessarily to accommodate
printing. Have ever wished you could put the
information from two worksheets together on
a single printed page? Well, you can do that too.
Just follow these steps:
1. Select the first worksheet tab that you want
2. Choose Page Layout > Page Setup >
Orientation (arrow) and select the appropriate
orientation for the data on the worksheet.
3. Select the worksheet tab corresponding
to any other worksheets that you want to
print and choose the appropriate orientation
for each worksheet.
1. Select a worksheet that will print on multiple
pages. You could also select multiple
4. Select the worksheets that you want to print,
following the steps in the previous section.
2. Choose File > Print. Excel displays the Print
5. Choose File > Print and confirm the page
orientation in the Print Preview window.
6. Click the Print button to print. Figure 10-3
demonstrates how pages in the same print
job can have two different orientations.
Not all printer models will be able to
perform this task.