Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Posts
    309
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repeat Column Headers (Excel 2002)

    I created a spreadsheet. In A1 thur E1 I have entered my column headers. In a2 thur E200 I entered data. When I print out thespreadsheet, I need my column headers on each page. Can I do this like in Word? I print the spreadsheet out it come on 4 pages.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Repeat Column Headers (Excel 2002)

    I don't have XP, so it might be slightly different:

    Select File/Page Setup...
    In the Sheet tab you can specify rows to be printed at the top of each page, by pointing, or by typing the reference. In your case, it would be 1:1.

Posting Permissions

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