Microsoft Office Tutorials and References
In Depth Information
Previewing Your Worksheet
Excel worksheets can incorporate large
amounts of data, not to mention charts and
other images. Once you’ve established the print
area and before you send all of that information
to the printer, it’s a good idea to get into the
habit of previewing your work, to make sure that
there are no surprises when your file reaches the
Printing Multiple Copies
Click the up or down arrows next to the
Copies option at the top of the Print Preview
window to print multiple copies of the ﬁle
in a single print job.
Choose File > Print to open Excel’s preview
window (see Figure 9-3). The preview displays
your worksheet exactly as it would appear if you
printed the file on paper. For instance, if the
selected printer prints only in black and white,
the preview window will also display in black
and white, even if your worksheet includes color
A piece of paper can be turned vertically or
horizontally. That directionality is called the paper’s
orientation . Take a closer look at the Print Preview
window. The preview shows the file in a vertical
(portrait) format. Excel’s default orientation is
Portrait. With this orientation set, Excel will
need two pages to print the selected print area.
You can change the orientation to try to reduce
the number of pages required to print the
worksheet. Click the arrow on the orientation option
and select Landscape Orientation (see Figure 9-4).
Excel changes the preview to reflect the new
paper orientation. Figure 9-5 demonstrates that
while more columns fit on this wider paper
orientation, the print selection still requires two
pages to fit.
Excel’s preview window.