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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat Rows at Top - Except Final Page 2
Repeating Rows - Exception 1
Change print titles (rows to repeat at top) on subsequent pages 2
repeat rows at top of page 4
Repeat row numbers 4
Repeat different rows on top 2
Repeat Pivot Row on when printing 1
Excel Excel spreadsheets opening at top instead of bottom. 4

Back
Top