How to Make a DVD List in Excel

If you have a large collection of DVDs, you may find them difficult to keep track of. You may find yourself in the video store looking to purchase a new DVD yet you can't remember if you already own it. A list of everything you own can track what you have so you don’t buy duplicates.

...
You can organize your DVDs in an Excel list.

Step

Separate a batch of DVDs from your collection to enter. Stack your DVDs so you can keep track of which titles you've entered and which still need to be done.

Step

Open Excel and create a new file. Create column headers beginning with “Title” for column A, row 1. Create a second column reading “Actor/Actress.” Set up subsequent columns to add any additional information about the film you want to store: additional actors, year of release or director. Whatever information you feel you'll be searching for later, enter it in now.

Step

Type the title of first movie in the batch in column A, row 2. Start titles with first word to be alphabetized. Push all leading articles to the end, after a comma, for example, "Princess Bride, The." Continue entering information in subsequent columns.

Step

Save the file with an easy-to-remember title such as "DVD list" or "Movie list." Periodically save the file as you work.

Step

Enter information for each additional movie title. Alphabetize when you've completed a batch of DVDs or at the end of the cycle by highlight all content under row 1 and clicking the "A-Z" button on the toolbar. Choose "Data" then "Sort" from the menu if you'd like to sort in order using other columns, such as the actor or release date.

Step

Set up an additional column for notations of DVDs that you lend to family and friends. Keep track of who has what and when they borrowed it.