(Msg. 1) Posted: Mon Sep 22, 2008 7:43 am
Post subject: Printing Headings Archived from groups: microsoft>public>excel>printing (more info?)
Hi! 22 Sep
We generate large reports in Excel, where subsections have headings which are
printed once, not repeated in each row.
While printing reports, the second page of each subsection (if the subsection
extends beyond one page ( which would depend on current printer setup)), the
second page onwards will not carry the subsection heading.
Is there any way I can convince 'Rows to repeat at top' to look for some last
printed heading and print it in the top of every page?
(Msg. 2) Posted: Mon Sep 22, 2008 2:17 pm
Post subject: Re: Printing Headings [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not too readily without VBA code but in any case you would wind up with
separate print jobs.
Might be easier to do that manually to start with.
Gord Dibben MS Excel MVP
On Mon, 22 Sep 2008 07:43:18 GMT, "bnmohan via OfficeKB.com" <u35859@uwe>
wrote:
>Hi! 22 Sep
>
>We generate large reports in Excel, where subsections have headings which are
>printed once, not repeated in each row.
>
>While printing reports, the second page of each subsection (if the subsection
>extends beyond one page ( which would depend on current printer setup)), the
>second page onwards will not carry the subsection heading.
>
>Is there any way I can convince 'Rows to repeat at top' to look for some last
>printed heading and print it in the top of every page?
>
>I dont thinkso, but I wish I am wrong.
>
>Mohan
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office