I have a very long excel (2003) s/sheet with in excess of 600 rows that I want to paste into an MS Word document (also 2003). However, I want to ensure that:

1) The header row appears automatically at the top of each page.

2) The s/sheet automatically formats to the correct page width (the one I have is slightly wider than my Word page).

This can obviously be done manually by cutting and pasting each page seperately but this is very laborious and time consuming and I once saw somebody achieve this automatically (maybe with a macro) but have been unable to locate them, or the methodology. Can anyone please assist?

Thanks in advance, Fred.