Assuming pre-XL2007: File | page Setup | open the Sheet Tab | specify which
rows (and/or columns) are to be printed on each page. You CANNOT do this
from PrintPreview
best wishes

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> Hi,
> How to use a certain row to be as a header on each page when printing?
> thanks