🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #675

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

#675
From: Christopher Davis
Date: Tue, 27 Jun 1989 09:59
26 lines
1856 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).  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.

I had the same problem--I expect it's fairly common.

Solution--use "Set Print Area" to *not* print the titles--you can still leave
'em at the top of the file, but they won't print.

- 						Jeff White
- 						University of Pennsylvania
- 						jeff@eniac.seas.upenn.edu
-- 
  /\  | /  |\  @bu-pub.bu.edu <preferred>  | Christopher K. Davis, Boston U.
 /    |/   | \ %bu-pub.bu.edu@bu-it.bu.edu |   [but not speaking for them]
 \    |\   | /  <for stupid sendmails>     | BITNET: smghy6c@buacca 
  \/  | \  |/  @bucsb.UUCP <last resort>  or ...!bu-cs!bucsb!ckd if you gotta.
Technical Details
Message-ID: <2712@bucsb.UUCP>
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!gatech!purdue!bu-cs!bucsb!ckd
References: <12405@netnews.upenn.edu>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!gatech!purdue!bu-cs!bucsb!ckd
From: ckd@bucsb.UUCP (Christopher Davis)
Newsgroups: comp.sys.mac
Subject: Re: Setting print titles in Excel (how to prevent double print)
Message-ID: <2712@bucsb.UUCP>
Date: 27 Jun 89 09:59:17 GMT
References: <12405@netnews.upenn.edu>
Reply-To: ckd@bucsb.bu.edu (Christopher K Davis)
Followup-To: comp.sys.mac
Organization: Boston University School of Management
Lines: 25