ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I print a single column of data in two columns on one page (https://www.excelbanter.com/excel-discussion-misc-queries/63859-how-do-i-print-single-column-data-two-columns-one-page.html)

Neal

How do I print a single column of data in two columns on one page
 
I have a single column of sorted data that I want to print with two or more
columns per page. Example: Page 1, column 1 = 1-10
Page 1, column 2 =11-20
Page 2, column 1 =21-30
Page 2, column 2 =31-40

Jim Cone

How do I print a single column of data in two columns on one page
 
Neal,

You can paste into Word and use Format | Columns or

David McRitchie has some code to try in Excel...
http://www.mvps.org/dmcritchie/excel/snakecol.htm

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Neal"
wrote in message

I have a single column of sorted data that I want to print with two or more
columns per page. Example: Page 1, column 1 = 1-10
Page 1, column 2 =11-20
Page 2, column 1 =21-30
Page 2, column 2 =31-40


All times are GMT +1. The time now is 04:41 PM.

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