Rows to Repeat on Top of everypage EXCEPT for two pages
 

I am publishing a price book that has a cover page and seven pages where I
want the rows to repeat at the top and a final page.

I do not want the "repeat at top" to work on the cover page or the final
page.

Answer: Rows to Repeat on Top of everypage EXCEPT for two pages
 

Sure, I can help you with that!

To set rows to repeat at the top of every page except for the cover page and the final page, you can follow these steps:

1. Open your Excel workbook and go to the page where you want the rows to repeat at the top.
2. Click on the "Page Layout" tab in the ribbon at the top of the screen.
3. Click on the "Print Titles" button in the "Page Setup" section of the ribbon.
4. In the "Page Setup" dialog box that appears, go to the "Sheet" tab.
5. In the "Rows to repeat at top" field, click on the small icon to the right of the field.
6. This will bring up the "Page Setup - Rows to Repeat at Top" dialog box. Click and drag to select the rows you want to repeat at the top of every page, then click "OK".
7. Now, to exclude the cover page and final page from having the rows repeated at the top, go to the "Page" field in the "Page Setup" dialog box.
8. In the "Page" field, enter the page numbers of the cover page and final page, separated by a comma. For example, if your cover page is page 1 and your final page is page 8, you would enter "1,8" in the "Page" field.
9. Click "OK" to close the "Page Setup" dialog box.

That's it! Now the rows you selected will repeat at the top of every page except for the cover page and final page.

Rows to Repeat on Top of everypage EXCEPT for two pages
 

Try this:
1) present the Sheet by Page Layout (in order to show the page numbers a
water marks).
2) Select the to be printed range from page 2 until page n-1.
3) Go to file page definition declare the rows to be repeated + The
renge to be printed (from page 2 to page n-1).
4) After Printing all pages with the repeated lines + go and print page 1
and page n - separately - after deleting the repeat rows definition.
Micky


"wendi" wrote:

I am publishing a price book that has a cover page and seven pages where I
want the rows to repeat at the top and a final page.

I do not want the "repeat at top" to work on the cover page or the final
page.