Results 1 to 6 of 6
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts

    Print column titles on all pages? (XP)

    Is there a way to make Excel put the column titles that I create on all the pages when it is printed out? As I scroll down onscreen, the column titles stay visible, it would be nice if they would print too.

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Print column titles on all pages? (XP)

    In PageSetup, if you select the Sheet tab you can specify in the Rows to repeat at top section the row(s) which you want to be included on each printed page.

    Andrew C

  3. #3
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts

    Re: Print column titles on all pages? (XP)

    Thanks for the info.
    When I went there and clicked the selection box next to Rows to Repeat at Top, I cntrl-clicked the 2 rows at the top, and it selected them all the way across the sheet. I hit Enter, then clicked OK, and it said "Print titles must be contiguous and complete rows or columns". But it seems like they are.
    Any ideas?
    Thanks

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print column titles on all pages? (XP)

    As Andrew is not on line at the moment I will assist.

    You need to enter 1:2 in the "Rows to repeat at top" box to print the top 2 rows on every page.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Print column titles on all pages? (XP)

    Don't cntl-click, (this enters them as 2 ranges)
    just select the first row and while holding down the right button, drag to "pick up" the second

    Steve

  6. #6
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts

    Re: Print column titles on all pages? (XP)

    Great! That did it!
    Thanks

Posting Permissions

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