Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Column Titles on multiple pages (MS Excel 2002)

    On a spreadsheet that "spills" over to a second or third page, how can the column labels be repeated at the top of page 2 and 3?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Column Titles on multiple pages (MS Excel 2002)

    Select Page Setup from the File menu, then click on the Sheet tab. In the box labeled "Rows to repeat at top," fill in the rows that contain the column titles. For example, if the column titles are in rows one and two, then enter $1:$2 in that box and Click OK. Rows one and two should now be repeated at the top of every page.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Jan 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Column Titles on multiple pages (MS Excel 2002)

    Thanks Legare! It worked perfectly! I very much appreciate your help!

Posting Permissions

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