Reapply a filter

If the values in the filtered range have changed during work, you can re-filter the data without changing the filter settings. To do this, proceed as follows:

1.On the Home tab, in the Data group or on the Data tab, click the arrow to the right of the  Filter button.

2.In the drop-down menu, select Reapply filter.