Forum Discussion
Printing spreadsheet
How can I put a frozen heading on each printed page?
Activate the Page Layout tab of the ribbon.
In the Page Setup group, click Print Titles.
Click in the 'Rows to repeat at top' box.
Select the row or rows at the top of the sheet that you want to be printed on each page.
You should see for example $1:$1 or $1:$2.
Click OK.