Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Prigorje Brdovecko, Croatia
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repeat first row in print on each page (Excel 2000)

    I have a table on 5 page excel spreadsheet. I want the first row to print on every page. Is there a simple way to make rows repeat at top?
    Ivana
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeat first row in print on each page (Excel 2000)

    File, Page setup, "Sheet" tab, click in the box next to "Rows to repeat at top" and select the row(s) you want on each page.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeat first row in print on each page (Excel 2000)

    Just to add to Jan Karel's Post, when using Rows to repeat at top and Columns to repeat, remember that Excel repeats the whole row or whole column, so it is important that you print preview your worksheet. A common problem that comes my way is odd data appearing on the last page. It is usually because people have not taken into account data at the far right on the worksheet or way down at the bottom of a column.

  4. #4
    New Lounger
    Join Date
    Dec 2002
    Location
    Dumfries, Virginia, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeat first row in print on each page (Excel 2000)

    You also have the option of including a header/footer. This is under "View" in the menu bar.

    JT

Posting Permissions

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