print multiple, separate rows on each page

G

Guest

How do I get Excel to print different rows on each page? I have table column
heading I want to print on each page and a notes section as well, which is
too large for a footer.
 
G

Guest

In File, Page Setup, Sheet tab there are "Rows to repeat at top" and "columns
to repeat at left". You should be able to select the rows you want, and they
should appear on each page printed. (This is present in Excel 2003, anyways.
I'm not sure about older versions).

Kevin
 

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

Print one line per page 3
same heading on each page while printing 1
Page break dosen't break 4
how can i print (row) titles on all pages except the last page? 3
wrap columns to print in rows 1
I trying to develop a macro to print my worksheets 1
Arggh! Each row prints on separate page 2
Printing multiple sheets... 1

Top