column snaking print format
David McRitchie has an answer for this exact question at this site
http://www.mvps.org/dmcritchie/excel/snakecol.htm "Montrose Lyle" wrote: I frequently prepare lists in Excel that have one or two columns and many rows. I would like to have them print as many "snaked" columns as will fit on a page to reduce the number of pages that will print, similar to the multi-column format in Microsoft Word. -- Lyle Montrose, Colorado ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Duke,
Thanks for the answer. It can be done, but it isn't easy. McRitchie's instructions run to nine pages, plus lots of links if you are not familiar with macros and such. I'll see if I can figure them out. It sounds like a lot of people have the same interest, or he wouldn't have written the macros. Maybe with enough response, Microsoft will finally provide us with a one-click solution like they provide in Word. -- Lyle Montrose, Colorado "Duke Carey" wrote: David McRitchie has an answer for this exact question at this site http://www.mvps.org/dmcritchie/excel/snakecol.htm "Montrose Lyle" wrote: I frequently prepare lists in Excel that have one or two columns and many rows. I would like to have them print as many "snaked" columns as will fit on a page to reduce the number of pages that will print, similar to the multi-column format in Microsoft Word. -- Lyle Montrose, Colorado ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
All times are GMT +1. The time now is 04:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com