+ Reply to Thread
Results 1 to 4 of 4

make first few rows print on every page?

  1. #1
    CD
    Guest

    make first few rows print on every page?

    I have the first few rows of my sheet frozen so that I can scroll down the
    long columns (about 3 printed page lengths) without losing sight of the top
    headings.
    I would like to be able to set it so that those top rows print at the top of
    each page.
    Is that possible? It would be a great deal easier than trying to repeat the
    heading columns at periodic intervals down the page becasue i don't know how
    to figure out where I would repeat them to make them be the top rows of each
    consecutive new page. Hope this makes sense.
    Thanks,
    CD

  2. #2
    Max
    Guest

    Re: make first few rows print on every page?

    Try:

    Click File > Page Setup > Sheet tab

    Under Print Titles, input* in box for:
    Rows to repeat at the top: $1:$2
    (to repeat the top rows1 and 2, for example)

    Click OK

    *Instead of keying-in, you could also just click inside the box,
    then click outside on any cell in row1, say select B1 and drag down to B2

    This'll also give return "$1:$2" inside the box
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "CD" <CD@discussions.microsoft.com> wrote in message
    news:D034EFF3-822E-4935-8A37-0A0BBC4F00AB@microsoft.com...
    > I have the first few rows of my sheet frozen so that I can scroll down the
    > long columns (about 3 printed page lengths) without losing sight of the

    top
    > headings.
    > I would like to be able to set it so that those top rows print at the top

    of
    > each page.
    > Is that possible? It would be a great deal easier than trying to repeat

    the
    > heading columns at periodic intervals down the page becasue i don't know

    how
    > to figure out where I would repeat them to make them be the top rows of

    each
    > consecutive new page. Hope this makes sense.
    > Thanks,
    > CD




  3. #3
    CD
    Guest

    Re: make first few rows print on every page?

    Thankyou. Going to see what I can do with those instructions.

  4. #4
    Max
    Guest

    Re: make first few rows print on every page?

    You're welcome !
    Should work ..
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "CD" <CD@discussions.microsoft.com> wrote in message
    news:3B29A3C8-0DC5-4A46-B71F-96F6C4C3C223@microsoft.com...
    > Thankyou. Going to see what I can do with those instructions.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1