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
thank you
3 Replies
Sort By
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.
- MumzeeCopper ContributorThanks! Created separate worksheets and voila problem solved.
Funny how getting back into something takes time, help & patience but remains fun in the end!
- MumzeeCopper ContributorUpdate. Got row one on all pages so only issue now is omitting it on last page!