ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing to 2 "columns area" (https://www.excelbanter.com/excel-discussion-misc-queries/162732-printing-2-columns-area.html)

Montrose guy

Printing to 2 "columns area"
 
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 !!

Augusta

Printing to 2 "columns area"
 
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 !!


RagDyeR

Printing to 2 "columns area"
 
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 !!




All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com