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

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

Bernard,

I liked your suggstion of using the mail merge to print complex lines.
I have several users that need to print the data from a wide Excel
spreadsheet. I tried to create a simple solution using the mail merge
feature an even created a set of "How to List records in the Excel
file" directions.

http://usatfne.org/records/

It appears that at least one of my users has a older Windows 98 system
(pre Windows 98SE) He cannot even display the PDF directions on his PC.
I would scare him off if I asked him to set up a mail merge.

Can I create a simple report on the second Excel worksheet that uses
the data from the first worksheet? I really need a one button solution
that will work on older versions of Excel.

I look forward to hearing from you. Thank you. -- Justin