Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

Filter Analysis Look at the first row of this spreadsheet. Each of the labels has a drop down list. These are the filters. You can use more than one. You can remove any filter by going to the drop down and selecting “Clear Filter.”   Here is a different view: Filter by Color.