To print the current worksheet using Excel's
defaults for printing click the Print button on Excel's Standard toolbar.
To control Excel's print options select File,
Page Setup to open the Page Setup dialog box. Note that this dialog has
four tabs: Page, Margins, Header/Footer, and Sheet .
You'll want to be familiar with these particularly
useful print options:
To specify an area to print
Go to the Sheet tab, click in the Print Area box
and then drag through the worksheet areas that you want to print. (Nonadjacent
ranges print on separate sheets.)
To print row & column headings & gridlines
Go to the Sheet tab and click in the "row and
column headings" and "gridlines" boxes to put check marks
in these boxes.
To print headers and footers
Click the Header/Footer tab and follow the prompts.
Note that a number of standard header entries (page, name, date, etc.)
To center the printout on the page
Click the Margins tab and check Center on page horizontally
or Center on page vertically .
To select portrait or landscape orientation
Click the Page tab and select whether you want Excel
to print down an 8 ½ x 11 page or across.
Fit to one (or x) page(s)
Click the Page tab and click the Fit to option in
the "Scaling" section. If you have a spreadsheet that's just
a row or column or two too large to fit nicely on a single page, this
is a lifesaver of an option. It reduces your entire spreadsheet in size
just enough to fit in the space you specify with the Fit to option.
Return to Top
Click Help on Excel's top-level menu. Select
Contents and Index. On the Contents tab click Printing.
Return to Top