Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How does this work then?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is not a problem. I've just come across a feature in Excel 97 that happens on one machine and not another.

    I have a basic sheet with the first 4 rows being used for basic column headers etc. The data is then input as usual in the cells below. When I print this sheet out, the first 4 rows are automatically printed at the top of each page. This makes life nice and simple for me, but the same sheet on another machine does not produce the same result. Is this a feature in Excel that can be simply turned on and off to suit user preference or does one machine have a bug?

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't know if you saved the file from one computer (A) and transfered the file to the other (B).

    Repeating the first four lines (or really any specified number) is a feature of Excel in the page setup. Click the "sheets" tab and click in the "Rows to repeat at top" field. Input or highlight on the page the area you want repeated on each page.

    I'm not sure why one computer does it over the other as I don't know how the file was transfered. If the file was saved and then transfered to the other computer, then the file was saved prior to initiating the feature. If the file was developed on the second feature, then the feature simply hasn't been toggled yet.

    -Dave

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can't figure that out myself,but that is the difference between the two. Don't know where the figures came from in the check box, but at least I know how to do it now.

    Thankyou.

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Pennsylvania, USA
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-29 07:33, croweld89 wrote:
    I don't know if you saved the file from one computer (A) and transfered the file to the other (B)...I'm not sure why one computer does it over the other as I don't know how the file was transfered. If the file was saved and then transfered to the other computer, then the file was saved prior to initiating the feature. If the file was developed on the second feature, then the feature simply hasn't been toggled yet.

    -Dave

    That may be a part of the *.xlt template file. If the template on the second machine is not set up for repeating the first four rows, it will {or should} not happen until this is turned on in Page Setup as you suggested!

    Just a thought...


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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