How to clear advanced filter in excel
 

If an advanced filter is set for a range and if I want to another area in the
sheet to be selected for advanced filter, the earlier area gets selected
automatically. Is there a way to clear the earlier selection?

Prakash Shukla

How to clear advanced filter in excel
 

Data Filter Show All


"Prakash Shukla" wrote:

If an advanced filter is set for a range and if I want to another area in the
sheet to be selected for advanced filter, the earlier area gets selected
automatically. Is there a way to clear the earlier selection?

Prakash Shukla