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