Wrapping Columns (Excel 2000)

Topic

New Reply

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)?

Reply | Quote

Replies

GirlFriday

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

Reply | Quote

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.

Reply | Quote

Rebecca, check out this thread. –Sam

Reply | Quote

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!

Reply | Quote