home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!portal!lll-winken!fnnews.fnal.gov!mp.cs.niu.edu!ux1.cso.uiuc.edu!news.cso.uiuc.edu!uxh.cso.uiuc.edu!rlarson2
- From: rlarson2@uxh.cso.uiuc.edu (Bob Larson)
- Newsgroups: comp.os.msdos.apps
- Subject: Re: lotus 123 v3.1 printing help
- Message-ID: <C1HHLE.MG5@news.cso.uiuc.edu>
- Date: 26 Jan 93 23:08:02 GMT
- References: <1993Jan26.200811.26816@athena.mit.edu>
- Sender: usenet@news.cso.uiuc.edu (Net Noise owner)
- Distribution: usa
- Organization: University of Illinois at Urbana
- Lines: 26
-
- In <1993Jan26.200811.26816@athena.mit.edu> gavin@mtl.mit.edu (Gavin C. H. Zau) writes:
-
- >Hello,
- >I am trying to print out a spread sheet from lotus 123 v3.1.
- >It is formatted with the 2 top sheet as a summary. Then there
- >are about 50 sheets that contains information formatted the same
- >way. Each of these sheets is 2x2 printout and I am trying to use
- >the boarders to print out the title of the sheet and the rows and
- >columns headings.
- >Unfortunately when I set the boarders to the first of the 50 sheets
- >I cannot get the boarders to change for the subsequent sheet. Is
- >there a way to set/copy the boarder ranges for each sheet so that
- >they will print out their own title and column/row headings???
- >This worksheet is updated and printed every month...
-
- >I am currently considering writing a macro for this. Thanks.
- When you set the borders, you can use the pg-up and pg-dn
- keys to set them across several sheets. That should do
- what you want.
-
-
- --------------------------------------------------------------------------
- Bob Larson Illinois State Water Survey
- blarson@uiuc.edu 2204 Griffith Drive
- Voice: (217)333-7955 Champaign, IL 61820
- Fax: (217)333-6540
-