Printing Same Columns across a page

[Guest]

I have a simple spreadsheet with two columns, item & price. Can I print this
sheet with these 2 columns repeating across the page. IE:

A B A B A B
1 1.00 2 .87 3 .50

 

[Dave Peterson]

To save paper?

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 that doesn't work for you, David McRitchie has a macro that will "snake" the
columns.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm