Explanation

Filter temporarily hides records that do not meet your selected condition.

Go to:

Data → Filter

Drop-down arrows appear in the header row.

Example

Filter City = Sirsa.

Result:

Order ID

Customer

City

Product

Sales

O101

Amit

Sirsa

Keyboard

4000

O103

Rahul

Sirsa

Monitor

25500

O105

Amit

Sirsa

Keyboard

4000

The original data is not deleted.

Practice

Apply filters for:

  • City = Sirsa
  • Category = Accessories
  • Product = Keyboard