Print Titles: "Rows to repeat at top:" option is greyed out.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The "Rows to repeat at top:" and "Columns to repeat at left:" options are
both greyed out in the sheet tab in the print settings menu. Any idea why or
how to fix?
(using Excel 2000 SP3)
 
Go to the File Menu to choose Page Setup.
Don't choose Setup from the Print Preview Window.
That should fix it.
tj
 
Are you in Print Preview mode?

Some items are grayed out in that case.

Go through File>Page Setup>Sheet

Gord Dibben Excel MVP
 
=?Utf-8?B?dGp0amp0anQ=?= said:
Go to the File Menu to choose Page Setup.
Don't choose Setup from the Print Preview Window.
That should fix it.
tj

"pgrams" wrote:

> The "Rows to repeat at top:" and "Columns to repeat at left:" options are
> both greyed out in the sheet tab in the print settings menu. Any idea why or
> how to fix?
> (using Excel 2000 SP3)
Click to expand...


This worked for me. THANKS!! (In Excel 2007, Page Layout tab -> little arrow bottom right gets you to "Page Setup". Here you can select, but not in "Page Setup" from Print Preview. Go figure.
 
yes that worked - stupid excel :bow:


Gord Dibben said:
Are you in Print Preview mode?

Some items are grayed out in that case.

Go through File>Page Setup>Sheet

Gord Dibben Excel MVP

On Fri, 12 Nov 2004 13:24:05 -0800, pgrams <[email protected]>
wrote:

>The "Rows to repeat at top:" and "Columns to repeat at left:" options are
>both greyed out in the sheet tab in the print settings menu. Any idea why or
>how to fix?
>(using Excel 2000 SP3)
Click to expand...
 
Back
Top