Home |
Search |
Today's Posts |
#1
|
|||
|
|||
column snaking print format
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 |
#2
|
|||
|
|||
Hi Lyle,
To read about installing and using macros see Getting Started with Macros http://www.mvps.org/dmcritchie/excel/getstarted.htm I have such a reference at the top of most of my pages with macros, I'll fix that omission. Since you mention 9 pages, the specific area you want to read the most is Attempting to Snake columns using Excel (#snakecols) http://www.mvps.org/dmcritchie/excel....htm#snakecols --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Montrose Lyle" wrote ... 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 |
#3
|
|||
|
|||
Maybe copying and pasting into MSWord and then using that would be sufficient.
In fact, if the list is plain old text, maybe keeping that list in MSWord would make more sense. Montrose Lyle wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print 3 column range in six columns | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Format Column with Same Function | Excel Worksheet Functions |