You could add pagebreaks after each row (and have rows to repeat at top set
nicely so that you have headers).
But if you wanted to make something like a form letter where the value in each
cell in the row would go into a different location on the form letter, you could
use your excel file as the database and use MSWord to do a mail merge.
Saved from a previous post:
Lots of times, it's easier to use MSWord for printing and Excel (or some other
database application) as the source.
You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge
The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.
And if you notice problems with the formatting of data (like zipcodes)...
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm
about half way down the page.
==========
I often cheat instead of racking my brain.
I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.
(Cheating doesn't bother me anymore <vbg>.)
======================
But if you want to use only excel, maybe something like this from Debra
Dalgleish's site:
http://contextures.com/xlForm03.html