What are the AutoFilter options available?
Finding and extracting data can be difficult when working with a large list. Excel offers the AutoFilter feature to define the data you want to work with and have Excel display only those records on-screen. Using this feature makes filtering out specific parts of your data as easy as selecting an option from a drop-down list. Simply choose from the menu bar Data – Filter – AutoFilter. Excel will add a drop-down arrow to the cells containing the list’s column labels. When you click on one of the arrows, an itemized list called the filter criteria will be displayed.
