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.
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.
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.
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.
Save the file with an easy-to-remember title such as "DVD list" or "Movie list." Periodically save the file as you work.
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.
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.
Tips & Warnings
- If you have an extensive collection on shelves or in cabinets, it can help to work with a second person.
- If you have all your computers on a home network, save to the "Shared Folders" section so that every computer in the house can access it.
- Excel sorts are rigid in their rules. Any title that begins numerically ("10 Things I Hate About You," "300") automatically ends up at the top of the list. To bypass this, you can enter numerical titles as words ("Three Hundred").
- Put all articles (A, An or The) at the end of titles.