Path: 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 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 | Christopher K. Davis, Boston U. / |/ | \ %bu-pub.bu.edu@bu-it.bu.edu | [but not speaking for them] \ |\ | / | BITNET: smghy6c@buacca \/ | \ |/ @bucsb.UUCP or ...!bu-cs!bucsb!ckd if you gotta.