Forum Discussion
Solved
Print treats like frozen rows, when there are none
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
etc.
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.
