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.

KBCategory: kbprint
KBSubcategory:

Additional reference words: 5.00 7.00 print_titles
Keywords : kbprint
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.