Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2009
    Posts
    471
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Making column titles print on multiple pages

    Hi,

    I am using Excel 2010. My row 3 of the spreadsheet consists of 5 columns labeled Date, Test 1, Test 2, Test 3, and Daily Average (A3,E3). How do I make this title row appear on multiple pages of the workbook?

    Thank you.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    In earlier versions of Excel ....
    File>Page Setup>Sheet>Rows to repeat at top
    and then choose your row 3

  3. #3
    New Lounger
    Join Date
    Dec 2010
    Location
    UK
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just as tfspry says, but in Excel 2010 you'll find it on the Page Layout ribbon at the right hand side of the Page Setup section - it's called Print Titles.

Posting Permissions

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