long list into printable view
 

I have a long list of items... thousands. Is there an easy way to count down
25 or 35 rows and cut and paste those entries into the next column over...
and do it again until you are to the end of the list. The idea being to have
a printable display on 5-8 pages rather than 25...

long list into printable view
 

I'd copy into MSWord (maybe hitting NotePad if MSWord slows down when I paste).
Then use MSWord's Format|Column to make life easy.

But if you want to stick with excel...

David McRitchie has some code to do this kind of thing at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

John wrote:

I have a long list of items... thousands. Is there an easy way to count down
25 or 35 rows and cut and paste those entries into the next column over...
and do it again until you are to the end of the list. The idea being to have
a printable display on 5-8 pages rather than 25...

--

Dave Peterson

long list into printable view
 

Thanks!

"Dave Peterson" wrote:

I'd copy into MSWord (maybe hitting NotePad if MSWord slows down when I paste).
Then use MSWord's Format|Column to make life easy.

But if you want to stick with excel...

David McRitchie has some code to do this kind of thing at:
http://www.mvps.org/dmcritchie/excel/snakecol.htm

John wrote:

I have a long list of items... thousands. Is there an easy way to count down
25 or 35 rows and cut and paste those entries into the next column over...
and do it again until you are to the end of the list. The idea being to have
a printable display on 5-8 pages rather than 25...

--

Dave Peterson