To fix the first row from scrolling:

Rows("2:2").Select
ActiveWindow.FreezePanes = True

To print row 1 of the current sheet on each printed page, use the following
code:

activeSheet.PageSetup.PrintTitleRows = "$1:$1"

Good Luck !


"ken" wrote in message
...
Dear all, I want to fixe the first rows and will be showed
whatever i scrolled and the row to be printed in each page

e.g.
Name Surname
aa xx
bb zz
cc kk
.
.

I want the first row will be show in all printed