How do I print

[keepout]

I use Excel for a grocery shopping list.
it's now expanded to about 80 items. I'd like to be able to read the list, but
it's so long now that the type is about 3 point.
What I'd like to do is print the list in 2 columns, and if it ever gets to this
size of type in 2 columns, I'd like to make more columns as necessary.

I tried just about every possible combo I could, but best I could come upwith
was it splitting the stuff into several pages. Not necessary. 2-3 columnson 1
page would be fine [better].

 

[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 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

I use Excel for a grocery shopping list.
it's now expanded to about 80 items. I'd like to be able to read the list, but
it's so long now that the type is about 3 point.
What I'd like to do is print the list in 2 columns, and if it ever gets to this
size of type in 2 columns, I'd like to make more columns as necessary.

I tried just about every possible combo I could, but best I could come up with
was it splitting the stuff into several pages. Not necessary. 2-3 columns on 1
page would be fine [better].

 

[keepout]

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.

Guess I'll have to go that route..

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

Way too complicated which might explain why it isn't a built in function.

I use Excel for a grocery shopping list.
it's now expanded to about 80 items. I'd like to be able to read the list, but
it's so long now that the type is about 3 point.
What I'd like to do is print the list in 2 columns, and if it ever gets to this
size of type in 2 columns, I'd like to make more columns as necessary.

I tried just about every possible combo I could, but best I could comeup with
was it splitting the stuff into several pages. Not necessary. 2-3 columns on 1
page would be fine [better].