list turned into two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an alphabetical roster from 1 to 100. I would like it so that 1-50 is
listed in the first column and 51-100 would list in the second column. The
problem is that when I want to add someone to the list I have to cut and
paste them all into the first column, then sort them and then re cut them
into the second column, etc... I am sure there is a really easy solution I am
a novice excel user
 
Excel doesn't do this very well.

Depending on what you're doing with the data, maybe you could use MSWord to make
it look nice. You can use format|columns and it'll wrap nicely.

If you want to keep the data in excel, maybe you could copy the data to MSWord,
then print from there.

Or keep your data in a single list and use a macro to convert it to multiple
columns...

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
 
Back
Top