LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jk
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lines not printing on second copy of my excel worksheet bjdeweese Excel Discussion (Misc queries) 0 November 8th 05 04:26 PM
select lines from multiple worksheets and write to new worksheet rem Excel Worksheet Functions 1 September 15th 05 03:35 PM
Charts Line Types for Multiple Data Series not Printing Properly Seanb Charts and Charting in Excel 0 August 22nd 05 06:35 PM
printing grid lines puddytatz Excel Discussion (Misc queries) 4 July 14th 05 07:35 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"