Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    same first line on all pages (2000 sp3)

    I heard once that one can make Excel show the same top line on all pages. For example, I have a long spread sheet where line 1 defines the columns across the front: "length, width, cost, retail cost" etc. The rows are numerous and become printed on several pages, but the column name is only on page 1.
    is there a way to automatically have excel put the column headings on these other pages?
    thanks

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

    Re: same first line on all pages (2000 sp3)

    Select File | Page Setup...
    Activate the Sheet tab of the dialog.
    Click in the "Rows to repeat at top" box, then point to row 1. (You can also click and drag to point to multiple rows, if desired)
    Click OK.

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

    Re: same first line on all pages (2000 sp3)

    In addition to what Hans said, if you also want the header row to remain on the screen as you scroll down the rows, then:

    1- Select cell A2.

    2- On the Window Menu, select "Freeze Panes".

    If you select cell B2, then it will freeze the first row and the first column. In other words, all cells above and to the left of the selected cell will be frozen.
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: same first line on all pages (2000 sp3)

    Thanks,
    Like a lot of Office things, the answer is burried somewhere.

Posting Permissions

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