I'm trying to make a word frequency spelling test resource book. I have a list of 36000 words ordered by their frequency of usage in English - they are currently in cells A1 to A36606 in an excel document.
I would like import this list of words into Microsoft Office. I'd like them to be split into groups of 20 words with 6 groups displayed on each page. Each group should have a heading e.g. "Test 1", "Test 2", "Test 3" etc. Below the heading should be the 20 words. So under "Test 1" would be the words from cells A1 to A20; under "Test 2" would be the words from A21 to A40 etc. Ideally each group of 20 words should be in alphabetical order (but this is something I can do without if it is troublesome).
What is the most efficient way of doing this?
I could just paste the list of words into a MS Word document that is already split into 3 collumns; then manually add in the "Test" headings and use the enter key to get 6 tests per page - but that seems like a messy and labour intensive way to do it.
Is there any way to set up a template in Word with a field for the Test number heading and fields for the 20 words per test and then merge the list into the fields?
Any advice would be much appreciated!
Thanks!
I would like import this list of words into Microsoft Office. I'd like them to be split into groups of 20 words with 6 groups displayed on each page. Each group should have a heading e.g. "Test 1", "Test 2", "Test 3" etc. Below the heading should be the 20 words. So under "Test 1" would be the words from cells A1 to A20; under "Test 2" would be the words from A21 to A40 etc. Ideally each group of 20 words should be in alphabetical order (but this is something I can do without if it is troublesome).
What is the most efficient way of doing this?
I could just paste the list of words into a MS Word document that is already split into 3 collumns; then manually add in the "Test" headings and use the enter key to get 6 tests per page - but that seems like a messy and labour intensive way to do it.
Is there any way to set up a template in Word with a field for the Test number heading and fields for the 20 words per test and then merge the list into the fields?
Any advice would be much appreciated!
Thanks!
