To create a filter in Excel, follow these steps:
- Ensure your data has column headers.
- Select any cell within your data range.
- Go to the Data tab on the Ribbon.
- Click the Filter button in the Sort & Filter group. This will add drop-down arrows to the header cells.
- Click the drop-down arrow in the column you want to filter.
- Choose the filter criteria by checking or unchecking items, or select from text/number filter options.
- Click OK to apply the filter. The data will now display only the rows that meet the filter criteria.
You can also toggle filters on or off quickly by pressing Ctrl + Shift + L. Filters can also be customized to filter with criteria like "contains," "begins with," or numeric conditions such as "greater than" or "between" values. This method works on both tables and regular data ranges in Excel.
