Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Montrose Lyle
 
Posts: n/a
Default 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   Report Post  
David McRitchie
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print 3 column range in six columns dawgpilot Excel Discussion (Misc queries) 3 April 28th 05 10:53 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 07:19 PM
Printing - Have to set print area 1 column further than necessary STUART BISSET Excel Discussion (Misc queries) 0 January 24th 05 08:59 PM
Format Column with Same Function Brett Patterson Excel Worksheet Functions 6 January 5th 05 08:43 PM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"