Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repeating Rows during Print (2000)

    I have a user who has a 10 page excel spreadsheet. She wants the first row to print on every page EXCEPT the last page. Is there any way to "suppress" the "Rows to repeat at top" on the last page?
    Thanks,
    Caroline in lala-land

  2. #2
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeating Rows during Print (2000)

    Well, here's a kind of klutzy but effective way to do it. Have your user create two print areas and store each of them as Views. The first print area can be stored with the repeating rows and the second print area can be stored without the rows. Then use Report Manager to create a print report that will print both print areas in a single report (even with consecutive page numbers, if the user wishes). The thing to remember about using Views is that when you store a print area you also store the page setup settings, so it is necessary to make sure the user first defines the print area correctly, then correctly sets the page setup settings, before saving as a View.

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •