The filter in a data range is very useful. Not only you can sort the dataset, but you can also filter the data based on certain criteria. Please see below how to create a filter:
Step 1: Click anywhere in the data range;
Step 2: Click the "Create a filter" button;
Step 3: The first row of the data range will become the filter.
Alternatively, you can always use the commands from the ribbon.
Step 1: Click anywhere in the data range;
Step 2: Click the "Data" tab from the ribbon;
Step 3: Click "Create a filter" from the drop-down list;
Step 4: The first row of the data will become the filter.
