Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2010, 09:57 PM
hatemail13 hatemail13 is offline How do you create a list similar to an itunes list? Mac OS X How do you create a list similar to an itunes list? Office 2007
Novice
How do you create a list similar to an itunes list?
 
Join Date: Jul 2010
Posts: 1
hatemail13 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-06-2010, 02:21 AM
mugezhn mugezhn is offline How do you create a list similar to an itunes list? Windows XP How do you create a list similar to an itunes list? Office 2007
Novice
 
Join Date: Jul 2010
Posts: 16
mugezhn is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft