in excel why is this necessary . if you highlight row before headings and
click
windows(menu)-freezepanes
the hedings row will remain as you scroll down even to 2000th row.

If there is some other reason, sorry.


ams0007 wrote in message
...
Kindly tel me how can i be able to put the header row before each row of a
data base contains about 20,000 rows in excel or access i.e.

Employee name employee ID Address
Asad 1007 xyz
Employee name employee ID Address
Jamil 1039 trb
.
.
.