Usually when you apply a filter to your Excel workbook it applies to the whole data tab. Sometimes you don’t want this.
Here is a great workaround from “Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More – 512 Excel Mysteries Solved” by Bill Jelen –
“Instead, select cells A1: D1 before selecting the Filter icon. This will add the dropdowns to only those columns. Of course , if you filter by column A, it will only show you the filtered rows for all of the columns.”
Start reading this book for free: http://amzn.to/1SEkhVQ