Printing repeating columns on the same page

[Guest]

Not really sure how to explain this... I have three columns of information.
Each column is not very wide but the number of rows is over 200. I can make
the columns where the three are less than half of the width of a printed page.

What I want to do is instead of having multiple pages which are only filled
halfway across I want to print two pages full size side by side... So that
it looks like this:

Page 1
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Page 2
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C
Column A | Column B | Column C | Column A | Column B | Column C


I need to be able to sort ascending and descending for each column as the
list is updated. So, I cannot just copy and paste into new columns... Any
help would be greatly appreciated.

 

[Pete_UK]

You might find this link to David McRitchie's site covers what you
want to do:

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

Hope this helps.

Pete

 

[Dave Peterson]

I like to copy the data into MSWord and use MSWord's builtin ability to do
column layout. With lots of data, I sometimes have to paste into Notepad
first--large tables cause me trouble in MSWord.

If you're not doing many calculations, you may just want to keep your data in
MSWord, too.