printing onto multiple lines
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 |
printing onto multiple lines
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 |
printing onto multiple lines
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 |
All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com