Forum Discussion
Mumzee
Mar 22, 2022Copper Contributor
Repeat row 1 on each page except last one
I am using Excel 2002 i have a spreadsheet with a custom header I want to also have row 1 of page 1 repeat on all pages but the last one is this possible? i can’t find how to do it in help than...
- Mar 22, 2022
Excel does not provide for that. You can specify one or more rows to be repeated on every page of the printed output in the Sheet tab of the Page Setup dialog, but it doesn't let you exclude the last page.
HansVogelaar
Mar 22, 2022MVP
Excel does not provide for that. You can specify one or more rows to be repeated on every page of the printed output in the Sheet tab of the Page Setup dialog, but it doesn't let you exclude the last page.
- MumzeeMar 24, 2022Copper ContributorThanks! Created separate worksheets and voila problem solved.
Funny how getting back into something takes time, help & patience but remains fun in the end!