Can anyone help with a filtering issue I have in 2007.

I am making a spreadsheet for purchase requisitions and need to have a number of filters on different data. When I try and apply these it only lets me put one filter on the page.

Or is there another way of selecting muliple data from eg drop down lists so that people cannot enter wrong information?