PRINT LONG ROWS

[Mary]

how can I "wrap" long rows with short columns of
information to print on the next line of the sheet rather
than the next page
thanks so much
Mary

 

[Jim Cone]

Mary,

There is nothing built into Excel to do this.
You have to write code, use some built in features in Word
or use a utility/add-in.

My Excel add-in "Side by Side" should do what you want...
Columns of data are arranged into two or three side by
side groups on successive pages. Data sequence is
maintained and the area above the data is not changed.
A new worksheet is created with the new column arrangement.
Your original worksheet is not affected.
You print from the new worksheet. It's easy to use and very fast.
Comes with one page Word.doc install/use instructions.
Available - free - upon direct request. Remove xxx from email address.

Regards,
Jim Cone
San Francisco, CA
(e-mail address removed)

 

[Ragdyer]

Check out this web page of David McRitchie's which tells how to accomplish
this.

http://www.mvps.org/dmcritchie/excel/snakecol.htm