I am trying to print the column labels on each of a 10 page list. When I go
to Page Setup, then the Sheet tab, the items under Print Titles are greyed
out. i.e. I can't enter a row for the "Rows to Repeat at Top" option.

Anyone know why? Can't find anything in the help file.

Thanks,
Tim

timz Wrote:
I am trying to print the column labels on each of a 10 page list. When I
go
to Page Setup, then the Sheet tab, the items under Print Titles are
greyed
out. i.e. I can't enter a row for the "Rows to Repeat at Top" option.

Anyone know why? Can't find anything in the help file.

Thanks,
Tim

Hi Tim

Sounds like you are trying to do this from Print preview, try File
Page Set up instead


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=402053

Thank You! That was it. Never would have figured that one out.

"Paul Sheppard" wrote:


timz Wrote:
I am trying to print the column labels on each of a 10 page list. When I
go
to Page Setup, then the Sheet tab, the items under Print Titles are
greyed
out. i.e. I can't enter a row for the "Rows to Repeat at Top" option.

Anyone know why? Can't find anything in the help file.

Thanks,
Tim

Hi Tim

Sounds like you are trying to do this from Print preview, try File
Page Set up instead


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=402053