Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple blocks (double column lists) turned into drop down list | Excel Discussion (Misc queries) | |||
Cursor turned to a square | New Users to Excel | |||
Sort is turned off. How do I turn it on? | Excel Worksheet Functions | |||
Worksheet has turned | Excel Worksheet Functions | |||
How is the Filter count turned on/off? | Excel Discussion (Misc queries) |