| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print a number of rows per page
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print a number of rows per page
Hi
see your post in Excel.misc -- Regards Frank Kabel Frankfurt, Germany girapas wrote: 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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print first two rows (heading) and one row per page... | Excel Discussion (Misc queries) | |||
| How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
| How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
| make first few rows print on every page? | New Users to Excel | |||
| How do I print a new number on each page | Excel Worksheet Functions | |||
Hybrid Mode
