Article View: comp.os.msdos.apps
Article #3257Re: lotus 123 v3.1 printing help
From: Bob Larson
Date: Tue, 26 Jan 1993 23:08
Date: Tue, 26 Jan 1993 23:08
26 lines
1724 bytes
1724 bytes
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
Technical Details
Message-ID:
<C1HHLE.MG5@news.cso.uiuc.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!portal!lll-winken!fnnews.fnal.gov!mp.cs.niu.edu!ux1.cso.uiuc.edu!news.cso.uiuc.edu!uxh.cso.uiuc.edu!rlarson2References:
<1993Jan26.200811.26816@athena.mit.edu>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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