ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel, how can print columns of data? (https://www.excelbanter.com/excel-discussion-misc-queries/49704-excel-how-can-print-columns-data.html)

kingant

In Excel, how can print columns of data?
 
I have a long skinny Excel worksheet. I'd like to print it to one page,
however this crunches it down to one column. Is there any way to force Excel
to make a mid-page break and create another column to continue with the data?

Dave Peterson

I'd copy the excel data into MSWord and print from there. Word has built in
support for multiple columns (Format|Columns, IIRC).

But if you want to stick with excel...

David McRitchie has some code to do this kind of thing at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm



kingant wrote:

I have a long skinny Excel worksheet. I'd like to print it to one page,
however this crunches it down to one column. Is there any way to force Excel
to make a mid-page break and create another column to continue with the data?


--

Dave Peterson


All times are GMT +1. The time now is 10:00 PM.

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