Sort & Filter

Two must-know tools to organize and find your data!

---

Sort

Arranges your data in order.

A to Z = Alphabetical (or smallest to largest)

Z to A = Reverse (or largest to smallest)

---

How to Sort

1. Click any cell in your data
2. Go to Data tab
3. Click Sort A to Z or Sort Z to A

---

Sort Example

Before sorting:

After Sort A to Z (by Name):

---

Sort by Multiple Columns

1. Select your data
2. Data → Sort
3. Add levels:
   • First: Sort by Department
   • Then: Sort by Name

---

Filter

Shows only the rows you want to see. Hides the rest.

---

How to Filter

1. Click any cell in your data
2. Go to Data tab
3. Click Filter
4. Dropdown arrows appear on headers!

---

Using Filter

Click the dropdown arrow → Choose what to show:

• ✅ Check items to show
• ❌ Uncheck items to hide
• Use Text Filters for "contains", "starts with"
• Use Number Filters for "greater than", "between"

---

Filter Example

Original data:

Filter: Show only "Apple"

---

Clear Filter

To show all data again:

Data → Clear (or click dropdown → Clear Filter)

---

Sort vs Filter

---

Keyboard Shortcuts

---

Summary

Sort:

• Arranges data in order
• A-Z or Z-A
• Can sort by multiple columns

Filter:

• Shows only what you need
• Hides other rows (not deleted!)
• Use dropdown arrows to select