You could filter based upon options you make from a list, or you could generate precise filters to deal with precisely the data that you might want to view. How can I set Excel 2007 so that upon opening, AutoFilter will have the "select all" box to become unchecked? Dropdown https://auto-filter18529.ageeksblog.com/32979090/the-basic-principles-of-auto-filter