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 !!

Hi,

Go to print preview and enter in the configuration options. Then select
adjust to 1 page wide and choose for the high the number that would fit
better for the amount of data you have.

"Montrose guy" wrote:

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 !!

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 !!