Enter 1:1 or just use the refedit box to point to row 1 on your sheet.

This is not "Freezing Panes"

Better you should have stuck to your original post for continuity.


Gord Dibben MS Excel MVP


On Sat, 26 Jul 2008 19:00:00 -0700, Judy Kay
wrote:

I have found the page setup and the sheet and Rows to repeat at top but
everything I put in it gives me an error. What is the special words I can
put in it to work.