Explanation

Excel allows multiple filters to be applied simultaneously.

For example:

City = Sirsa
AND
Category = Accessories

Only records satisfying both conditions remain visible.

Clear Filter

Use:

Data → Clear

This removes the applied filter conditions.

Reapply

Data → Reapply

Reapplies the current filter after the underlying data has changed.

Example

Filter:

• City = Sirsa
• Category = Accessories

Result:

Order ID	Customer	Product	Category	Sales
O101	Amit	Keyboard	Accessories	4000
O105	Amit	Keyboard	Accessories	4000

Practice

Create these filtered reports:

Report 1: Sirsa + Accessories
Report 2: Hisar + Sales ≥ ₹5,000
Report 3: Hardware + Sales > ₹20,000