Rows To Repeat At Top

T

Tiziano

I am using Excel 2000 for Windows.
When I print out a spreadsheet, I would like to be able to repeat
certain rows (namely Rows 1 and 2) only where a page break has
been _manually_ inserted in the spreadsheet.
Anyone knows if this is possible and how to do it?
Thanks in advance for any tips.
 
K

KLassman

You should be able to go to File/Page SetUp/Sheet. Find the "Rows to
Repeat at Top" field, click on the field. It will take you back to
your spreadsheet and you can highlight the rows you want repeated.
 
T

Tiziano

With your solution, however, rows will be printed also when a page break
is automatically inserted in the spreadsheet. I would like to print certain
row headers only where a _manual_ page break has been inserted.
 
Top