Printing with more than one column per page

  • Thread starter Thread starter Robin S.
  • Start date Start date
R

Robin S.

I'm using the term, "column" incorrectly here. I want to print a list
of records, but I want to have 2 or three "columns" of records per
page. Word can do this using the "columns" control, but I can't figure
out how to get Excel to do this, or how to get Word to import an Excel
file such that I can do this.

The item is an electronic price list, and it's going to be over 100
pages if each line is one record, and it's mostly blank space.

Thanks for any suggestions. I'm using Excel and Word '97.

Regards,

Robin
 
Robin,

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. 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)
 
David McRitchie has a web page devoted to just this subject.

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I'm using the term, "column" incorrectly here. I want to print a list
of records, but I want to have 2 or three "columns" of records per
page. Word can do this using the "columns" control, but I can't figure
out how to get Excel to do this, or how to get Word to import an Excel
file such that I can do this.

The item is an electronic price list, and it's going to be over 100
pages if each line is one record, and it's mostly blank space.

Thanks for any suggestions. I'm using Excel and Word '97.

Regards,

Robin
 
Back
Top