+ Reply to Thread
Results 1 to 3 of 3

print a long list with 2 columns

  1. #1
    Bucky
    Guest

    print a long list with 2 columns

    I have one long column of data. Is there some way to have it print out
    in 2 "columns" per page? Like in Word, if I have a long list, I can set
    it to have 2 columns to accomplish this. Any similar Excel features?


  2. #2
    Paul B
    Guest

    Re: print a long list with 2 columns

    Bucky, have a look here for a way to do it,

    http://www.mvps.org/dmcritchie/excel/snakecol.htm

    If you're not familiar with macro's, see "Getting Started with Macro and
    User Defined Functions": here
    http://www.mvps.org/dmcritchie/excel/getstarted.htm
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003


    "Bucky" <uw_badgers@email.com> wrote in message
    news:1142012158.457998.304840@p10g2000cwp.googlegroups.com...
    >I have one long column of data. Is there some way to have it print out
    > in 2 "columns" per page? Like in Word, if I have a long list, I can set
    > it to have 2 columns to accomplish this. Any similar Excel features?
    >




  3. #3
    Bucky
    Guest

    Re: print a long list with 2 columns

    Paul B wrote:
    > Bucky, have a look here for a way to do it,
    > http://www.mvps.org/dmcritchie/excel/snakecol.htm


    Thanks, that was a great resource. I think the best and most convenient
    solution is to simply copy the columns into Word and use the Column
    feature in Word. Although the SnakeCols macro seemed pretty cool, by
    the time I enter the parameters and run the macro, I could printed from
    Word as well. Seems so simple, yet I didn't think of it. =)


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1