ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multi-Column Printing (https://www.excelbanter.com/excel-discussion-misc-queries/38506-multi-column-printing.html)

Glenn Chung

Multi-Column Printing
 
I have an XLS with 3 column which only occupies about half of a letter size
paper. How can I do a multi-column printing that continues to the right side
of the paper before start printing on a new page? (Just like how I can do
columns in Word or like a magazine article with multi-column) Please help!
Thanks!

Glenn

Dave Peterson

I'd just copy the range to MSWord and print there.

But David McRitchie has a macro that does this kind of thing:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Glenn Chung wrote:

I have an XLS with 3 column which only occupies about half of a letter size
paper. How can I do a multi-column printing that continues to the right side
of the paper before start printing on a new page? (Just like how I can do
columns in Word or like a magazine article with multi-column) Please help!
Thanks!

Glenn


--

Dave Peterson


All times are GMT +1. The time now is 07:10 AM.

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