PRINT TITLES is Grayed Out

jays35

New Member
Joined
Oct 11, 2016
Messages
10
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
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Alex Blakenburg

MrExcel MVP
Joined
Feb 23, 2021
Messages
3,657
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Oct 11, 2016
Messages
10
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,811
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Is it disabled for all worksheets/workbooks or only certain ones?
 

jays35

New Member
Joined
Oct 11, 2016
Messages
10
Thanks for the reply. I did check some others and they are also grayed out.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,811
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,323
Messages
5,836,637
Members
430,442
Latest member
Zephreo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top