Filters can enable the user to display rows that contain a certain value or criteria.
The AutoFilter command applies drop-down arrows on the lower right side of the column so that you can select which items to display. When a certain item is selected, Microsoft Excel temporarily hides the rows that do not fit the criteria. Let's explore the use of filters with the use of a simple exercise. To activate Filters, go to the menu bar and select Data-Filter and AutoFilter. 3, notice the drop-down arrows next to the Names, Items and Qty cells.