Have you tried the AutoFilter feature? It's under Data-Filter. First, highlight the whole document, not just the column to be filtered, then click on Data-Filter-AutoFilter and then "bang", it gives you a tiny down-arrow. Hope this helps.
How do you create a drop down list of a select number of values in excel?
for example I want a user to select when they want a certain task completed. If spreadsheet was left blank I would get all kinds of invalid data. If I supply a drop down list of answers such as Monday, Tuesday, Wednesday, etc... then I would only get those answers back.
I know that you start with an unused column and add the values wanted in the list there but I can't figure out how to get the drop down created back in the column I want and have it show the values I want.
Using WinXP but I don't think the OS matters with this question.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic