We help IT Professionals succeed at work.

excel 2016 - page setup - sheet/ rows to repeat at top - disabled

excel 2016 - page setup - sheet/ rows to repeat at top - disabled

hi experts for some reason, this feature is disabled & i dont know how to turn on, please help.

page setup - sheet/ rows to repeat at top - disabled
Comment
Watch Question

System Administrator
BRONZE EXPERT
Distinguished Expert 2018
Commented:
Instead of File -> Print -> Page Setup, open the worksheet -> Page Setup as shown in the picture.
pagesetup.png
Kesavan JeganarayananIT Consultant
BRONZE EXPERT

Commented:
If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart.
Also, check to verify that at least one printer is set up in Windows.

On the Page Layout tab, in the Page Setup group, click Print Titles.
Frank .SBuilding Estimator

Author

Commented:
thankyou experts