How to Add a Filter to the Range

One easy way to sort a data range is to add a filter which will stay with the data range whenever you use it till you clear it. Please follow below for details:

Step 1: Select the row you want to filter on, normally the top header row;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort & Filter" and select "Filter" from the drop-down list;

Step 4: You will find the small triangles in the selected row; click the small triangle in a column and filter the data.

Leave a Reply