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.