Why Are My Print Titles Greyed Out Excel? Print titles may appear greyed out and unselectable if the worksheet is protected or viewed in Page Layout mode. To enable print title selection, exit these modes by unprotecting the sheet and returning to the Normal view. Can I Use A Macro To Set...
Read More: How to Print Gridlines in Excel How to Print Titles for Better Documentation Go to the Page Layout tab. From the Page Setup group, select Print Titles. From the Page Setup window, go to the Sheet tab. In the Print Titles section, you can set which row(s) or column(s) ...
Why Is Print Titles Button Greyed Out? If you cannot access thePrint Titlesbutton, it might be because you are editing a cell or have a chart selected. Similarly, if you cannot use the Rows to repeat at the top spreadsheet icon, it could be because you have selected multiple worksheets ...