Filters Make Excel Good To The Last Drop

Filters are a powerful tool in Excel that allow you to eliminate extraneous information from your view. For example, filters can be used to only show you the rows that have John Doe as the sales person or only show you rows that have blank cells in a certain column. In order for filters to work properly, your range needs to have a column heading (a label at the top of each column). You turn on filters by clicking inside your range and then choosing Home-Sort & Filter-Filter. Voila, a drop down…