Filters Make Excel Good To The Last Drop

October 9, 2018


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…

Join the Discussion

American Society of Administrative Professionals

Producer of

APC  EA Ignite