Page Setup problem

G

GCF

Why is it that sometimes “Page Setup” grays-out “Rows to repeat at top”
making it inaccessible?

Thank
 
G

Gord Dibben

Two possible reasons come to mind.

1. You entered Page Setup through "Print Preview". Enter it through
File>Page Setup and RTRAT will be available.

2. You have more than one sheet selected as in "grouped". If you see [group]
after the filename in Title Bar, right-click on any sheet and "ungroup".

Gord Dibben Excel MVP
 
Top