Print with page break after each line

  • Thread starter Thread starter Bruce Roberson
  • Start date Start date
B

Bruce Roberson

I am working with a user in my office. He has a page
header set up of lets say about 15 rows. Then, he has
below that a list of about 500 records he wants to print.

The header should print, then the first record/row should
print on that page, then there should be a page break, and
then the header again with just the second record/row and
so on through the list until all 500 pages are printed.

Is there a way to set Excel up to do this without a macro
and without manually putting page breaks in between each
record?

Thanks,


Bruce
 
Another rain forest hits the dust ;-)
It you are sure you don't want to do it with a macro - try this..
1. In Page setup make your header rows(s) print at the top of each page (rows to repeat at top)
2. Go into print preview and adjust the bottom margin so that just the header and one row below, fits on one page
3. Print

This will work if all the record rows are the same depth

M
 
Back
Top