Forum Discussion

Mumzee's avatar
Mumzee
Copper Contributor
Mar 22, 2022
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...
  • HansVogelaar's avatar
    Mar 22, 2022

    Mumzee 

    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.

Resources