Open the Page Layout tab
Look for the Page Setup group (second from left)
Click Print Titles (last item in group)
Fill in the Rows to Repeat ... on the dialog box (eg $1:$2 to repeat the
first two rows on each page)

For more search Help with: <Row to Repeat as your search term
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"slavenp" wrote in message
...
How do I set up that the heading of the colums prints off on each page.
I'm
using v.2007. Thanks.