Lesson 4.2 – Sorting Data

Lesson 4.2 – Sorting and Filtering in Tables

Sorting and filtering are two of the most powerful features of Excel Tables. They allow you to organize, analyze, and explore your data quickly and efficiently. In questa lezione impari come ordinare e filtrare i dati in modo professionale.

---

1. Sorting Data in a Table

Sorting means arranging your data in a specific order, such as:

• Alphabetical (A → Z or Z → A)
• Numeric (smallest → largest or largest → smallest)
• Date order (oldest → newest or newest → oldest)

How to sort:

1. Click the filter arrow in the column header.
2. Select Sort A to Z or Sort Z to A.

Sorting inside a Table keeps all rows aligned, preventing data corruption.

---

2. Filtering Data in a Table

Filtering allows you to show only the rows that match specific criteria.

How to filter:

1. Click the filter arrow in the column header.
2. Check or uncheck the values you want to display.
3. Use Text Filters, Number Filters, or Date Filters for advanced options.

Filtering is essential for exploring large datasets without deleting or moving data.

---

3. Clear Filter

To remove all filters and show the full dataset:

Home → Sort & Filter → Clear

Or click the filter icon again and choose Clear Filter.

---

4. Using Search Inside Filters

Each filter menu includes a search box. This is extremely useful when:

• You have long lists of values
• You need to find a specific item quickly
• You want to filter by partial text

Example: typing “pro” will show “Product A”, “Project X”, “Profile 1”.

---

5. Combining Sorting and Filtering

You can apply both sorting and filtering at the same time. For example:

• Filter only “Electronics”
• Then sort by price from highest to lowest

Excel Tables maintain data integrity even with multiple filters applied.

---

6. Filter by Color

If your Table uses conditional formatting or manual colors, you can filter by:

• Cell color
• Font color
• Icon set (from conditional formatting)

This is useful for highlighting errors, priorities, or categories.

---

7. Practical Exercise

Practice sorting and filtering with the following steps:

1. Create a worksheet named Lesson_4_2_Practice.
2. Insert a Table with at least 20 rows of sample data.
3. Sort by a numeric column (ascending and descending).
4. Filter by a text category.
5. Use a Number Filter (e.g., “Greater than 50”).
6. Use the search box inside the filter menu.
7. Clear all filters.

---

Internal Links

• Lesson 4.1 – Creating and Formatting Tables
• Lesson 4.3 – Structured References
• Lesson 4.4 – Total Row and Automatic Calculations

---

Next Lesson

Lesson 4.3 – Structured References