Print Page Setup|Sheet

[doco]

On the 'Sheet' tab of the Page Setup Tabbed Dialog the "Print area:', 'Print
titles' TexBoxes are grayed out and unavailable for use. How are these
activated?

TIA

doco

 

[Gord Dibben]

doco

Two things come to mind that would cause this problem.

1. You opened the dialog through "Print Preview" which makes these items
unavailable.

2. You have two or more sheets selected or "grouped".

Gord Dibben Excel MVP

 

[doco]

Hmmmmmmm... How then, pray tell, would one get to the Print|Page
Setup|Sheet Tabbed Dialog?


doco

 

[doco]

Never mind. File|Page Setup works quite nicely. Although, I am not clear
why it is important that these options be grayed from Print Preview?

Thanks
doco