Setting print titles in Excel (how to prevent double print)

Article View: comp.sys.mac

Article #644

#644

From: Jeffrey M White
Date: Mon, 26 Jun 1989 15:18

15 lines
1229 bytes

  I'm using the "Set Print Titles" in Excel (currently v1.5) to have the first
line of my document (which is the column titles for my file) print at the top
of every page.  That works fine.  What I'd like to know is if there is an
easy way to suppress it printing twice for the 1st page (once for the
page title, and twice for being a regular line in the file).  I'm sure that
I could probably put that line way at the bottom of the file, set it to be
the print title, and then select the page range when printing to avoid it,
but that's a real hassle, and doesn't allow me to see the titles at the top
of the screen when entering data.
  Any help would be appreciated.

						Jeff White
						University of Pennsylvania
						jeff@eniac.seas.upenn.edu

Technical Details

Message-ID: <12405@netnews.upenn.edu>

Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!netnews.upenn.edu!eniac.seas.upenn.edu!jeff

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!netnews.upenn.edu!eniac.seas.upenn.edu!jeff
From: jeff@eniac.seas.upenn.edu (Jeffrey M White)
Newsgroups: comp.sys.mac
Subject: Setting print titles in Excel (how to prevent double print)
Message-ID: <12405@netnews.upenn.edu>
Date: 26 Jun 89 15:18:26 GMT
Sender: news@netnews.upenn.edu
Reply-To: jeff@eniac.seas.upenn.edu (Jeffrey M White)
Organization: University of Pennsylvania
Lines: 15