General discussion

Locked

Duplicare titles on 2 pages

By Stevenhir ·
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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| 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!

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums