jeff@eniac.seas.upenn.edu (Jeffrey M White) (06/26/89)
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
levin@bbn.com (Joel B Levin) (06/27/89)
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."
ckd@bucsb.UUCP (Christopher Davis) (06/27/89)
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.