|
Posted to microsoft.public.excel.programming
|
|
|
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
|