To use sorting and filtering options in Excel:
- Open the dataset in Excel
- On the Data tab, in the Sort and Filter group, click the arrow next to the Sort & Filter icon
- Select a specific sorting or filtering option
- Specify the sorting or filtering criteria and settings
- Click the
OK
button