Yes, Excel has a feature that allows you to change the print titles (rows to repeat at top) on subsequent pages. Here's how you can do it:
- Open the Excel file that you want to modify.
- Click on the "Page Layout" tab in the ribbon.
- Click on the "Print Titles" button in the "Page Setup" group.
- In the "Page Setup" dialog box, go to the "Sheet" tab.
- In the "Rows to repeat at top" field, enter the rows that you want to repeat on every page of the first section. For example, if you want to repeat rows 1 and 2, enter (without the quotes).
- Click on the "OK" button to close the dialog box.
- Go to the first page of the second section.
- Click on the "Page Layout" tab in the ribbon.
- Click on the "Print Titles" button in the "Page Setup" group.
- In the "Page Setup" dialog box, go to the "Sheet" tab.
- In the "Rows to repeat at top" field, enter the rows that you want to repeat on every page of the second section. For example, if you want to repeat rows 5 and 6, enter (without the quotes).
- Click on the "OK" button to close the dialog box.
Now, when you print the Excel file, the rows that you specified will be repeated at the top of every page of their respective sections. Excel will automatically switch between the two sets of rows as it prints the different sections.