Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wrapping Columns (Excel 2000)

    I have a worksheet with two very long but narrow columns. Is there a way to wrap the columns to print multiple times on one page (like you can with Word columns)?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Wrapping Columns (Excel 2000)

    GirlFriday <img src=/S/hello.gif border=0 alt=hello width=25 height=29>

    OK you want to print these columns multiple times on a page, how about:

    1) Making a range that has these columns repeated multiple times as much as they would fit onto a sheet.

    2) How about using "Columns To Repeat at Left" and this way you will get them twice on a sheet.

    Its not clear from your post what you need to do, so maybe you can explain...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: Wrapping Columns (Excel 2000)

    Rebecca, check out <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=81359&page=&view= &sb=&o=&vc=1>this thread</A>. --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>

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrapping Columns (Excel 2000)

    I'm not sure the columns repeating at left would work, because it would repeat the same info each time, whereas I would like to get the column to continue on to the next bit of data. for instance if I had a column with a series of numbers in it. One number a row from one to one hundred, and on the first page, only the first 52 rows would print. I would like it to then start again with number 53 through 100 on the same page in a continuing column to the right of the first column.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston, Massachusetts, USA
    Posts
    205
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrapping Columns (Excel 2000)

    Thank you. That answers my question. However, I guess the bigger question is for microsoft. Why in the world do they offer the feature in Word and Access, but not in Excel?
    Oh well, ours is not to wonder why - or at least that what Mr. Gates wants us to think!

Posting Permissions

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