Printing spreadsheet

Copper Contributor

How can I put a frozen heading on each printed page?

1 Reply

@JHARDTKE0011 

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.