Oct 15 2021 07:49 AM
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.
Oct 15 2021 08:00 AM - edited Oct 15 2021 08:00 AM
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.
Oct 15 2021 08:13 AM
SolutionOct 15 2021 08:13 AM
Solution
Thank you! That was it... I cleared it out, and now it prints as expected. THANKS!