If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sorting problems in excel
I have a subscription that makes a new list every month. It has a list of songs from four seperate discs with title names, artist names, dates, disc numbers and other criteria.
I have cut and pasted the lists together in excel but it will only sort within each individual disc and not as a whole list. example. I have 100 discs with 18 songs on it each disc is numbered 1 - 100 I have everything pasted on one sheet as I received them in chronological order I want to have the entire list alphabetize by artist but when I try my result is that it will only alphabetize each artist list within each individual disc not the entire list as a whole. when prompted I ask it to include all cells to the left and right yet I dont get the right results what am I not getting? |
#2
|
|||
|
|||
sorting problems in excel
Try selecting the whole range first--don't let excel guess where it should end.
Then use data|sort to sort that selection. mokachu wrote: I have a subscription that makes a new list every month. It has a list of songs from four seperate discs with title names, artist names, dates, disc numbers and other criteria. I have cut and pasted the lists together in excel but it will only sort within each individual disc and not as a whole list. example. I have 100 discs with 18 songs on it each disc is numbered 1 - 100 I have everything pasted on one sheet as I received them in chronological order I want to have the entire list alphabetize by artist but when I try my result is that it will only alphabetize each artist list within each individual disc not the entire list as a whole. when prompted I ask it to include all cells to the left and right yet I dont get the right results what am I not getting? -- mokachu -- Dave Peterson |
#3
|
|||
|
|||
thank you .. I actually saw it work!
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge with Excel, field problems | fblair | General Discussion | 3 | October 22nd, 2005 01:14 PM |
excel Problems | TUNGANA KURMA RAJU | General Discussion | 1 | October 12th, 2005 09:25 AM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Problems opening Excel | Ali | General Discussion | 3 | August 30th, 2004 07:37 PM |
Problems : cannot open mail with attachments- Word, Excel etc | sarah rosen | General Discussions | 3 | June 16th, 2004 03:16 AM |