One way of doing this is with 'freeze panes'.
If you want Row 1 to always be visible click in Cell A2, go to Window
Freeze panes.

If you wanted it to show the columns as well, then perform the same,
but have cell B2 selected.

It won't change the way that the document prints however.

Hope this helps,
Hywel
Manchester UK


--
Hywel
------------------------------------------------------------------------
Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824
View this thread: http://www.excelforum.com/showthread...hreadid=345804