🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #648

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

#648
From: Joel B Levin
Date: Mon, 26 Jun 1989 18:23
18 lines
1239 bytes
In article <12405@netnews.upenn.edu> jeff@eniac.seas.upenn.edu (Jeffrey M White) writes:
|
|  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).

Pretty easy, you may kick yourself (but don't): when you set the
"Print area" (with "Set Print Area", _exclude_ those rows and columns
you have used for your print titles.

	/JBL


UUCP:     levin@bbn.com (new) or {backbone}!bbn!levin (old)
INTERNET: levin@bbn.com       		POTS: (617) 873-3463
   "Earn more sessions by sleeving."
Technical Details
Message-ID: <41986@bbn.COM>
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!bbn!bbn.com!levin
References: <12405@netnews.upenn.edu>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!bbn!bbn.com!levin
From: levin@bbn.com (Joel B Levin)
Newsgroups: comp.sys.mac
Subject: Re: Setting print titles in Excel (how to prevent double print)
Message-ID: <41986@bbn.COM>
Date: 26 Jun 89 18:23:32 GMT
References: <12405@netnews.upenn.edu>
Sender: news@bbn.COM
Reply-To: levin@BBN.COM (Joel B Levin)
Organization: BBN Communications Corporation
Lines: 18