Rows To Repeat At Top

  • Thread starter Thread starter Tiziano
  • Start date Start date
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.
 
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.
 
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.
 
Back
Top