PRINT TITLES is Grayed Out

[jays35]

Sorry if this has been asked and answered before.

My Print Titles box is 'grayed' out and I have tried several suggestions from others with no luck. Any suggestions? I have tried from Page Setup, File and Print, nothing is Frozen, and I don't see anything happening on my sheet.

Thanks in advance!

Dave

 

[Alex Blakenburg]

I think from File and Print it may be greyed out for everyone it certainly is for me on Excel 365.

I assume you have tried this from a previous question page:-
Excel 2016 - Print Titles greyed out
per @MacroMaker: "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."

I assume Print Titles are currently blank right ?

 

[jays35]

Alex,

Thanks for the reply and I did look at all of those setting and options. I searched and tried several suggestions with no luck.

Thanks again!

 

[RoryA]

Is it disabled for all worksheets/workbooks or only certain ones?

 

[jays35]

Thanks for the reply. I did check some others and they are also grayed out.

 

[RoryA]

Close Excel, search your hard drive for a file called Excelnn.xlb (where the nn will be a number based on your version of Excel). If you find it, rename it to say Excelnn.xlb.old and then try Excel again.