Option for Page Headers in excel is greyed out!

[Stoffel24]

Does anyone have an idea as to why the option "Rows to repeat at top" is greyed out on my Excel worksheet. Even on a new worksheet, with a few random characters inserted here and there (to ensure we get more than 1 page to print) I cannot get this option to activate. Hope you have some ideas. Thanks
Scott

 

[xlbo]

Are you going into Setup from print preview or from File>Page Setup ?? Rgds
~Geoff~

 

[xlhelp]

In addition to Geoff's comment, some of the options will also be greyed out if multiple sheets are selected. In your case what Geoff has suggested is more likely.