I would try merging the data to a Word document
See http://www.mvps.org/dmcritchie/excel/mailmerg.htm
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jk" wrote in message
oups.com...
I have a simple Excel 2002 file containing multiple records, each with
37 columns, most of which are text. I would like to print a one page
wide report of those records that is easy to view. The default Excel
settings creates a report that is two or more pages wide even in
landscape mode.

I modified the report by hiding several columns, optimized the column
widths, printing in landscape mode, and scaling the report to print one
page wide. Although the report is now just one page wide, the font is
just too small to be usable.

The report would be work if, for each row, I could print the first 20
columns on one line and print the remaining columns on next line
underneath the first. I'm not too familiar with Excel but am willing to
learn. Would you suggest a way to print onto multiple lines? Do you
know of any examples?

Thank you. -- Justin