RE: [ProgSoc] Excel Question.

Haiying Shi (Haiying.Shi.haiyings@nospam.nt.com)
Wed, 17 Sep 1997 07:43:07 -0400


Well, if you go to the Excel File menu, and then go down the the Page
Setup. One of the option in the page setup says Rows to Repeat at Top.
In you case, choose the first 5 rows you want to repeat on each page. I
am using Excel 7, not sure whether Excel 5 can do the same ...

Regards

Haiying

ESN: 642-7087
DIR: 61-2-9937 7087
E-mail: Haiying_Shi@nospam.nortel.com

>----------
>From: Freelancer[SMTP:supra@nospam.progsoc.uts.edu.au]
>Sent: Wednesday, 17 September 1997 21:22
>To: The Programmers' Society
>Subject: [ProgSoc] Excel Question.
>
>Does anyone out there know how to print certain rows of a spreadsheet on
>every page of the whole printout?
>What I mean is, say if there are 100 rows, and I want to print 5 rows on
>every page while printing the rest of them in order. It would look like;
>
>Page 1 contains rows 1 to 20 (if 20 is the max no. of rows per page)
>Page 2 contains rows 1 to 5 then 21 to 35
>Page 3 contains rows 1 to 5 and 36 to 50
>
>It would be great if you can tell me how to do it, and will be even
>greater if you could tell me how to do that in Excel 4.0
>
>
>Sincerely,
>Jihong
>
>--
>You are subscribed to the progsoc mailing list. To unsubscribe, send a
>message containing "unsubscribe" to progsoc-request@nospam.progsoc.uts.edu.au.
>If you are having trouble, ask owner-progsoc@nospam.progsoc.uts.edu.au for help.
>
>This list is archived at <http://www.progsoc.uts.edu.au/lists/progsoc/>
>

--
You are subscribed to the progsoc mailing list. To unsubscribe, send a
message containing "unsubscribe" to progsoc-request@nospam.progsoc.uts.edu.au.
If you are having trouble, ask owner-progsoc@nospam.progsoc.uts.edu.au for help.

This list is archived at <http://www.progsoc.uts.edu.au/lists/progsoc/>