list turned into two columns
 

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

list turned into two columns
 

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

Fipp wrote:

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

--

Dave Peterson