ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Can a few long, narrow Excel cols be "wrapped" to fill print pag (https://www.excelbanter.com/setting-up-configuration-excel/90107-can-few-long-narrow-excel-cols-wrapped-fill-print-pag.html)

Limousin Jim

Can a few long, narrow Excel cols be "wrapped" to fill print pag
 
I have three long, narrow columns of data requiring eight printed pages. Is
there a way that I can print these in "newspaper columns", i.e. have the
three columns wrap once or twice (as a group) to fill the print page before
continuing on the next page? Thanks for any help!!

Dave Peterson

Can a few long, narrow Excel cols be "wrapped" to fill print pag
 
David McRitchie has a macro that will "snake" the columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

Personally, I'd copy into MSWord (maybe hitting NotePad if MSWord slows down
when I paste).
Then use MSWord's Format|Column to make life easy.

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

Limousin Jim wrote:

I have three long, narrow columns of data requiring eight printed pages. Is
there a way that I can print these in "newspaper columns", i.e. have the
three columns wrap once or twice (as a group) to fill the print page before
continuing on the next page? Thanks for any help!!


--

Dave Peterson


All times are GMT +1. The time now is 05:06 PM.

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