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

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.