Why is the Print Titles option in Page Setup:Sheet greyed out?

T

timz

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
 
P

Paul Sheppard

timz said:
I am trying to print the column labels on each of a 10 page list. When
go
to Page Setup, then the Sheet tab, the items under Print Titles ar
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 instea
 
Top