Spreadsheets: Printing, Part VIII

 Back     "Getting Started" Home    Excel Review Home

 

VIII. Printing
    Printing Basics
    For More Information

 

Printing Basics

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.) are provided.

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

 

For More Information

Click Help on Excel's top-level menu. Select Contents and Index. On the Contents tab click Printing.

 

Return to Top