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 than...
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.
Update. Got row one on all pages so only issue now is omitting it on last page!