Refresh the filter

If the values in the selected 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 Refresh filters.