printing 2 pages in one A4

[esber]

Please help. How do I print in excel. I have data of 5000 rows and each
row has 3 columns. Each A4 page can take around 80 rows of data. In
order to save on paper, I was wondering if I could divide the page to
accommodate 6 rows by printing rows 1-80 on left side of an a4 page
and then rows 81-160 on the right side of the page. And then rows 161
to 241 on the left and rows 321 on the right side of page 2. And so on
until the total 5000 rows are printed. I know I can do this page by
page one at a time using the printscreen option but I was hoping I
could set it up so the printing could be done for the whole 5000 rows.
The columns are narrow (roughly 5 characters only) so no problem
fitting 6 columns in a page. But how do I do this so the printing
could be done continuously for the whole worksheet. thank you so much

 

[Jim Cone]

esber,

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)