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