![]() |
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 !! |
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 !! |
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