Check out this web page of David McRitchie:

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

--

HTH,

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

"Montrose guy" wrote in message
...
My worksheet in Excel 2003 has only 4 columns A-D.. takes about 1/2 the
width
of a letter-size printed page..but the data extends down for MANY rows.
SO..
when I print.. I have 4 pages with only data on the LEFT side.. the entire
RIGHT side is empty with plenty of room to print the 2nd page contents on
the
right..THEN move to page 2 and repeat the same order.. turning my 4 page doc
into a 2 pager.. I know there MUST be a way to force my data to be printed
in
this manner.. Pease HELP !!