Microsoft KB Archive/105203

= Microsoft Knowledge Base =

XL: Print Selection Does Not Ignore Print Titles
Last reviewed: March 27, 1997

Article ID: Q105203

5.00 5.00c 7.00 7.00a | 5.00 5.00a

WINDOWS              | MACINTOSH kbprint kbtlc

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for Windows 95, versions 7.0, 7.0a
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a
 * Microsoft Excel for Windows NT, version 5.0

SUMMARY
In Microsoft Excel, print titles will always be printed if they are defined.

This is by design.

To remove the print titles:


 * 1) From the File menu, choose Page Setup.
 * 2) Select the Sheet tab.
 * 3) Under Print Titles, clear the Rows To Repeat At Top and Columns To Repeat At Left boxes.
 * 4) Choose OK to accept the change.

MORE INFORMATION
In Microsoft Excel when you print your document, you can select one of three print options under Print What in the Print dialog box.

This option        Prints the following -

Selection          The selected range (or selected sheets, if in                       group edit mode) on the active sheet.

Selected Sheets    The printable area of the active sheet (or                       sheets, if in group edit mode) is printed.

Entire Workbook    The printable area of all sheets in the workbook is printed. If you choose to print the selection only, Microsoft Excel ignores any print area that you may have defined on any of your sheets and prints only the currently selected area.

This situation does not apply to print titles. Microsoft Excel will always print defined print titles regardless of which print option you select.