How does this work then?

Mr Nick · Apr 29th, 2002, 08:25 AM

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?

croweld89 · Apr 29th, 2002, 08:33 AM

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

Mr Nick · Apr 29th, 2002, 08:38 AM

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.

brilliner58 · Apr 29th, 2002, 08:38 AM

Quote:

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...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 08:25 AM	#1
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	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?

Apr 29th, 2002, 08:33 AM	#2
croweld89 New Member Join Date: Mar 2002 Posts: 34	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

Apr 29th, 2002, 08:38 AM	#3
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	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.