Microsoft Office Tutorials and References
In Depth Information
Excel automatically selects your regular printer. If you have more than one
printer installed and you want to use a different printer, you need to select
this printer yourself. You can also adjust printer settings by clicking the
Printer Properties link. Every printer has its own set of options here, but common
Properties settings include print quality and paper handling (like double-sided
printing for those lucky enough to have a printer that supports it).
Print Active Sheets prints the current worksheet. Print Entire Workbook prints
all the worksheets in your file. Print Selection prints out just a portion of a
worksheet. To make this feature work, you need to start by selecting a range of cells,
columns, or rows before you start your print out, and then choose File ➝ Print.
By default, Excel prints as many pages as it needs to output all the data you’ve
chosen to print. Alternately, you can choose a range of pages using the Pages
option. For example, you can choose to print only the first three pages by typing
1 into the first box and 3 instead the second. You can also print just the fourth
page by printing from 4 to 4.
Note: In order to use the “Print range” box effectively, you need to know how many pages you need to
print your worksheet and what data will appear on each page. You can step through all the pages in your
printout using the handy print preview shown in Figure 14-36.
Orientation is one of the all-time most useful print settings. It lets you control
whether you’re printing on pages that are upright (choose Portrait Orientation)
or turned horizontally on their sides (choose Landscape Orientation). If Excel
is splitting your rows across multiple pages when you print your worksheet, it
makes good sense to switch to landscape orientation. That way, Excel prints
your columns across a page’s long edge, which accommodates more columns
(but fewer rows per page).
If you’re fed up with trying to fit all your data on an ordinary sheet no matter
which way you turn it, you may be tempted to try using a longer sheet of paper.
You can then tell Excel what paper you’ve decided to use by choosing it from the
list just under the orientation setting. (Of course, the paper needs to fit into your
printer.) Letter is the standard 8.5 × 11-inch sheet size, while Legal is another
common choice—it’s just as wide but comes in a bit longer at 8.5 × 14 inches.
Beneath the options for page orientation and paper size is the margin setting,
which determines the amount of space between your worksheet content and the
edges of the page.