You are here: Home / Printing

How to print more than one sheet in a workbook

November 4, 2008 By

To print more than one worksheet in a workbook then :

1. Select the worksheets you want to print.

  1. If the sheets to be printed are adjacent then click on the first one, press SHIFT then click the last one.
  2. If they are not then click on the first one, press CTRL then click the others one at a time.

2. In the File menu click Print.

3. The Print window will open.

4. At the bottom of the Print window find a section labeled: Print what .

5. Click on the radio button labeled: Active sheet(s) .

6. Click OK.

Applies to Excel 2003

Filed Under: Printing Tagged With: , ,

How to Repeat Heading Row(s) on Every Page

April 16, 2008 By

If you have one or more heading rows in your worksheet and you want to print that worksheet then the heading row(s) will be printed on the first page only (default).

To print the heading row(s) on every page do the following:

  1. Click File then click Page Setup .The Page Setup window will open.
  2. Click the Sheet tab.

Heading to repeat

  1. In the Sheet tab click Rows to repeat at top
  2. Now go to your worksheet and select the row(s) which have the headings. The selected row(s) will be reflected in the Page Setup window.
  3. Click File –> Print Preview to verify that the heading row(s) will be repeated on every page, then print your worksheet.

Applies to: Excel 2003

Filed Under: Formatting, Printing Tagged With: , , ,

How to print part of a worksheet

April 10, 2008 By

If you have a worksheet and you only want to print part of that worksheet then follow the steps below:

Method 1

  1. Click File then click Page Setup .The Page Setup window will open.
  2. Click the Sheet tab.

    3. Print Area0

  1. In the Sheet tab click Print Area
  2. Now go to your worksheet and highlight the cells you want to print. The Print Area in the Page Setup window will be updated automatically with the cells references.
  3. Now every time you print the worksheet only the specified area will be printed.
  4. To print the whole sheet, clear the Print Area before you start printing.

Method 2

  1. In your worksheet, highlight the cells you want to print.
  2. Click File –> Print Area –> Set Print Area.
  3. The print area is now set to your selection.
  4. To print the whole sheet, Click File –> Print Area –> Clear Print Area.

Print Area1

Applies to: Excel 2003

Filed Under: Data, Printing Tagged With: , , ,
Newer Posts »