I think I mis-understood, 'I'm not sure really what you are trying to do.
Take a look at Niek's answer. If that is right,fine. If not give a little
more detail on what you are trying to do

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"jstluv2smile" wrote in message
...
Hello, Nick!
How nice of you to respond so quickly. Would your response reply to
someone
who wants to copy a column heading so that it can be viewed on top of the
page for each new page? Again, thanks.

"jstluv2smile" wrote:

What must I do in order to repeat a row on each page of my spreadsheet?
Can you help? Thanks!