Print same header at top of each printed page
 

I am looking to print the same header at the top of each printed page. I
have gone to File/Page Setup/Sheet. It then says rows to repeat at top
and I have put in the row number, it then says "reference not valid".
Is there a syntex problem or Am I totally wrong?


--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=481018

Print same header at top of each printed page
 

Good evening God's Kid

After the first read of your post I couldn't figure out what might be
wrong, but after reading it more literally, I figured it out.

Excel expects you to click on the ref edit icon on the right of the box
and select a row to print on every page. Once you do this the sytax
becomes something like this:

$1:$2

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=481018

Print same header at top of each printed page
 

Thank you very much that was the problem and it worked.


--
God's Kid
------------------------------------------------------------------------
God's Kid's Profile: http://www.excelforum.com/member.php...o&userid=28426
View this thread: http://www.excelforum.com/showthread...hreadid=481018

Print same header at top of each printed page
 

Hi God's Kid

Great stuff. Appreciate the feedback.

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=481018