ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrap cells from one column across the page? for printing list (https://www.excelbanter.com/excel-discussion-misc-queries/52932-wrap-cells-one-column-across-page-printing-list.html)

Trudy - TSC

Wrap cells from one column across the page? for printing list
 
one long list of data in column - eg 45000 rows
Wrap the list across the page to reduce pages for printing
eg from A53 wrap remainder of list to B1 the C1 and so on

Rowan Drummond

Wrap cells from one column across the page? for printing list
 
See:

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

Hope this helps
Rowan

Trudy - TSC wrote:
one long list of data in column - eg 45000 rows
Wrap the list across the page to reduce pages for printing
eg from A53 wrap remainder of list to B1 the C1 and so on


Dave Peterson

Wrap cells from one column across the page? for printing list
 
Have you thought of bringing the data into MSWord. You can use format|columns
and make it look nice.

Trudy - TSC wrote:

one long list of data in column - eg 45000 rows
Wrap the list across the page to reduce pages for printing
eg from A53 wrap remainder of list to B1 the C1 and so on


--

Dave Peterson


All times are GMT +1. The time now is 12:03 PM.

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