Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Long Report (Excel 2003)

    I have a spreadsheet that has just 2 colums, but 3325 rows. How can I print a report that will truncate the information, so I'm not printing the 78 pages with just two columns. Basically I don't want to waste space on the paper.

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Long Report (Excel 2003)

    The easiest way is to copy the data, then paste it into Word and use multiple columns. However, a normal paste took forever on this crummy computer, so I had to use Paste Special, Unformatted text. There is a complete discussion at http://www.mvps.org/dmcritchie/excel/snakecol.htm which also includes an Excel macro to do it. Also, Jim Cone has a free Excel Addin to do this, but you have to request it via email jim.coneXXX@rcn.comXXX (remove the XXX, he dosn't like spam). I've not tried Jim's addin. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Long Report (Excel 2003)

    Another free add-in that does this is ASAP Utilities

    Within the ASAP Utilities menu you select "Format>The paper saver (split columns)"

  4. #4
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Long Report (Excel 2003)

    Sam,

    Thanks for the mention.
    Your welcome to give it a try.
    Also, it doesn't load your system up with 400 other programs, most of which you will never use.
    It's easy to use, fast and still free upon direct request..
    (Remove XXX from my email address.)

    Regards,
    Jim Cone
    San Francisco, CA
    jim.coneXXX@rcn.comXXX

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Long Report (Excel 2003)

    Thanks to you both for the info. I'll send you an email Jim. Thanks again

Posting Permissions

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