Check out this link to David McRitchie's page on the subject:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"imac1948" wrote in message
...
Probably an easy problem for the Excel Wizard. However, not for me.
Presently I have a price list that is 3 columns wide and extends to over
300
pages if printed in its current format.

I would like to move the data so that it shows/prints page 1 and 2 on a
single sheet of paper. There would be room on single sheet of paper for
the
3 rows of data for pages 1 and 2. Thereby reducing the printed version to
half.

Thanks for any help