Print a number of rows per page

  • Thread starter Thread starter girapas
  • Start date Start date
G

girapas

I have an Excel workbook with 2 sheets. One of them is for data entering
(e.g. rows: employee's name, ID#, working dates, fee etc.) and the other
presents that data among other constant value cells (e.g. name of company,
titles of columns, place for signatures etc.). What I want is when data in
the presentation sheet reach at 22 rows to be automatically continued to the
next page of the sheet. So, each printed page will always shows 22 rows of
data with the constant data ABOVE and BELOW of these 22 rows. Thanks,
 

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

Back
Top