Selecting your data range. Clicking "Filter" on the Data tab (dropdown arrows appear on headers). Clicking the dropdown arrow for the column you want to filter. Choosing filter criteria (e.g., "Equals") and entering the value. Clicking "OK" in the dropdown menu.