Filter on just part of a tab in Excel

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:

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: