#1
|
|||
|
|||
How do you create a list similar to an itunes list?
I am trying to create a list that is similar to how iTunes organizes its music. I'm trying to create three columns (Year, Film, Director) in excel. That part is easy. But i want to be able to organize/sort the columns easily. For instance if I want to view all the rows by year, i would be able to do either ascending or decending. If i want to view all the rows by the the film, i want to view it alphabetically and in reverse. If i want to view the rows by director, i want to view it alphabetically and in reverse. How do I achieve this with keeping the rows (Year, Film, Director) in tact whenever I switch the ascending/descending ordering of something? Basically, I want to do an itunes version of a list of movies that can be sorted out easily. Thank you |
#2
|
|||
|
|||
You can use the "Sort" functionality of Excel. You select the whole data you want to start (in your case Year, Director, Movie) then choose Data>Sort. Under this menu you specify which column/s you want to sort, the order etc.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fonts List | kai1 | Word | 0 | 02-22-2010 04:16 PM |
Create Expandable Topic/List in Outlook 2007 | MJS | Outlook | 0 | 02-10-2010 03:15 PM |
Create Expandable Topic/List in Word 2007 | MJS | Word | 0 | 02-10-2010 03:13 PM |
[Office]How to create project timeline similar to this? | Coderedpl | Project | 0 | 09-11-2009 01:23 PM |
create a hotkey for "add sender to blocked senders list" | mytoyo | Outlook | 0 | 03-29-2009 09:39 AM |