I have one long column of data. Is there some way to have it print out
in 2 "columns" per page? Like in Word, if I have a long list, I can set
it to have 2 columns to accomplish this. Any similar Excel features?
I have one long column of data. Is there some way to have it print out
in 2 "columns" per page? Like in Word, if I have a long list, I can set
it to have 2 columns to accomplish this. Any similar Excel features?
Bucky, have a look here for a way to do it,
http://www.mvps.org/dmcritchie/excel/snakecol.htm
If you're not familiar with macro's, see "Getting Started with Macro and
User Defined Functions": here
http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Bucky" <uw_badgers@email.com> wrote in message
news:1142012158.457998.304840@p10g2000cwp.googlegroups.com...
>I have one long column of data. Is there some way to have it print out
> in 2 "columns" per page? Like in Word, if I have a long list, I can set
> it to have 2 columns to accomplish this. Any similar Excel features?
>
Paul B wrote:
> Bucky, have a look here for a way to do it,
> http://www.mvps.org/dmcritchie/excel/snakecol.htm
Thanks, that was a great resource. I think the best and most convenient
solution is to simply copy the columns into Word and use the Column
feature in Word. Although the SnakeCols macro seemed pretty cool, by
the time I enter the parameters and run the macro, I could printed from
Word as well. Seems so simple, yet I didn't think of it. =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks