Excel 2016 - Print Titles greyed out

[Xcel Chic]

[FONT=&quot]I am using Excel 2016 and want to add rows to repeat. I've tried the three approaches listed below. No matter which way I use, the Print Area and Print Titles are all greyed out and cannot be accessed, although I can change everything under Print Titles (Gridlines, Black & White, etc). Any idea how I can fix this?[/FONT]
[FONT=&quot](1) click Print icon => click Page layout at the bottom of the print options[/FONT]
[FONT=&quot](2) click Page Layout on ribbon => click bottom right arrow of "Page Setup"=> click "Sheet" tab in the menu ribbon[/FONT]
[FONT=&quot](3) click Page Layout on ribbon => click Print Titles[/FONT]

 

[MacroMaker]

I read many posts, but none of the solutions worked. Most common solution was to make sure you access Print Titles from the Page Layout tab on the top ribbon. That didn’t work for me.

This did work for Excel 2016: Go to View in top ribbon, make sure at far left you are NOT on Page Layout. You can be on Normal or Page Break Preview. Now go back to Print Layout on the top ribbon and select Print Titles. If this was your problem,it should not be greyed out anymore, but rather ready to enter rows or columns.