Forum Discussion

sewancestry's avatar
sewancestry
Copper Contributor
Oct 15, 2021
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 al...
excel
  • sewancestry's avatar
    sewancestry
    Oct 15, 2021

    HansVogelaar 

     

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

HansVogelaar's avatar
HansVogelaar
MVP
Oct 15, 2021

sewancestry 

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.

  • sewancestry's avatar
    sewancestry
    Copper Contributor
    Oct 15, 2021

    HansVogelaar 

     

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

Resources