Print treats like frozen rows, when there are none

New Contributor

Microsoft Office Home and Student 2016 on Windows 10 pc

Spreadsheet has NO frozen rows, nor any manual page breaks (I have unfrozen all, and removed all manual page breaks)

Yet upon printing, it always prints rows 1-5.

So page 1 has 1-6

page 2 has 1-5, then row 7

page 3 has 1-5, then row 8



2 Replies


Activate the Page Layout tab of the ribbon.

In the Page Setup group, click Print Titles.

Make sure that the 'Rows to repeat at top' box is empty.

best response confirmed by sewancestry (New Contributor)

@Hans Vogelaar 


Thank you!  That was it...  I cleared it out, and now it prints as expected.  THANKS!