Disabled "Print column or row titles on every page" on the sheet tab in page setup.

R

Rich Hollenbeck

How do I enable the "Print column or row titles in every page button? In
page setup it is disabled (grayed out.)
 
B

Bernard Liengme

I expect you came at it from Print Preview.
Use File | Page Setup and open the Sheet tab; it will be available here.
best wishes
 
G

Gord Dibben

If you are trying to set up the page through "Print Preview" this will be
grayed out.

Fix..........Go in through File>Page Setup.

If you have more than one sheet selected this will be grayed out.

Fix............Ungroup sheets by right-click on a sheet tab and "Ungroup
sheets".


Gord Dibben Excel MVP
 
R

Rich Hollenbeck

Nope, I came at it through File/Page Setup.

Bernard Liengme said:
I expect you came at it from Print Preview.
Use File | Page Setup and open the Sheet tab; it will be available here.
best wishes
Click to expand...
 
R

Rich Hollenbeck

No, I passed through File>Page Setup. Thanks for the insight about sheet
groupings. I have never heard of this before. I think maybe another
problem was that I may have had it set for one page wide and three pages
tall when I wanted the opposite to display multiple pages for a column. I
think that it was when I fixed that problem that the thing began to work
again.
 
Top