When using excel you can print a row title on each page using page setup/sheet/ and entering the row mumber in 'rows to repeat at top'. Can the same/similar be done in word when having loads of pages? Hope this can be understood!!
Its not! What I do is copy/paste a whole lot of data from excel into word. Then using format/columns I select two columns and all the data may take up 25 pages! What I want is the heading that I have in row 1 in excel to be row 1 on every page in word! Complicated I know!
Nice One Scotty! And if that doesn`t work try this in Word:
View>Header/Footer - Then Insert>File - navigate to the excel file. Then select the worksheet name from the first drop down box and the row data in the second. (You have to type the Excel range in the second) It may not look right until you go to print preview but it should print right providing you format it correctly.
This is what I do. I have 3 columns in excel the first says 'part' the second 'description' the third 'price' and it can contain anything upto 3000 rows. I put them in alphebetical order by 'part' using sort and set the font size to 8 so they fit into 2 columns when copied into word. Like I say I copy into word, format>columns>2 columns and I would like the 'part, description, price' to show on each page. (Office suite 97 upwards).
When you copy your data from excel and paste it into word, you will probably find that it is actually pasted in as a table. Select the row(s) that are to be headings and then go to Table\Heading Row Repeat.