Quick summary
The Filter feature in Microsoft Excel lets you instantly narrow down rows in a range or table by applying text, number, or value-based criteria. Mastering Excel data filtering helps analysts, business users, and students surface only the records that matter without deleting or moving data.
Steps
- Select a cell within your data range or table to set the filter starting point.
- Go to the Data tab and click Filter to enable dropdown filter arrows on your column headers.
- Click the filter arrow on the column you want to filter, then select Text Filters or Number Filters from the dropdown menu.
- Choose a comparison operator (for example, Between) to define how your filter criteria will be applied.
- Enter your filter criteria in the dialog box and click OK to apply the filter to your data.
- To filter by specific values, click the filter arrow, uncheck Select All, then check the boxes for only the values you want to display, and click OK.
