General discussion


Duplicare titles on 2 pages

By Stevenhir ·

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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Check the Page Setup

by noemib In reply to Duplicare titles on 2 pag ...

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!

Related Discussions

Related Forums