Discussion Locked

Duplicare titles on 2 pages

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Question-

When I created 2 pages of an EXCEL 2000 spreadsheet, I observe that the 2nd sheet has the first 3 lines as the first sheet. How can I resolve this problem?

Stevenhir@aol.com

1 reply

by noemib

It seems like your Excel sheet is setup to repeat certain rows at the beginning of each page. To check this, go to File> Page Setup. Click on the "Sheet" tab. In the Print Titles section, erase any data in the field named "Rows to repeat at top". Click OK. This should now resolve your problem. Note: These instructions are for Excel 2000.

Hope this helps!

This discussion is closed to new replies.