"Print Titles" in Excel is disabled. How to enable it?

[Ravi]

The "Print Titles" while doing Print preview for an Excel worksheet(s) is
coming as disabled. I am unable to select row(s) and/or column(s) to repeat
on every page while printing. What should be done to enable this?

 

[Niek Otten]

That option is always disabled in the print preview.
Use the Page Setup command in rhe File menu.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Ravi]

Thanks,
It worked - quite simple.

Regards,
Ravi

That option is always disabled in the print preview.
Use the Page Setup command in rhe File menu.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Jake M.D.]

What about in Office 2007? I click on the "Office Button" but there is not a
page set-up option.

 

[David Biddulph]

According to the 2003 to 2007 translation guide at
http://office.microsoft.com/en-us/help/HA101491511033.aspx?pid=CH102457041033,
there's a Page Layout tab in 2007, and an arrow at the bottom of that.

 

[lindaesser]

According to the 2003 to 2007 translation guide at
http://office.microsoft.com/en-us/help/HA101491511033.aspx?pid=CH102457041033,
there's a Page Layout tab in 2007, and an arrow at the bottom of that.

 

[Melanie]

Wow. Grrr! thanks, I never would have known!

That option is always disabled in the print preview.
Use the Page Setup command in rhe File menu.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel