🧠 Why Sorting & Filtering Matters
Whether you’re handling sales reports, customer lists, or student scores, sorting and filtering help you:
🔢 Organize data in meaningful order
👀 Quickly find what you need
📉 Analyze large datasets efficiently
🧭 Step-by-Step Guide
🔠 1. Sorting Data – A to Z or Z to A
✅ Basic Sort
📍 Select your column
➡️ Go to Home → Sort & Filter
Choose:
🧩 Example:
| Name | Score |
|---|
| Rani | 95 |
| Karthik | 82 |
| Amit | 77 |
Sort by Score (Z to A) → Highest scorer first
📊 2. Sort by Multiple Levels (Advanced)
➡️ Go to Data Tab → Sort
🎯 Add “Sort by” rules
Example:
First by Department
Then by Name (A-Z)
🎯 *Perfect for structured reports
*
🧰 3. Filtering Data – Show What You Need
🧪 Basic Filter
📍 Select header row
➡️ Go to Data Tab → Filter
🔽 Small drop-down arrows appear
Click the arrow to:
✅ Select specific values
🔍 Search specific names/text
📅 Filter by date/month/year
💯 Apply number filters (e.g., >80)
🎯 Example:
Filter “Status” column to only show:
✅ “Completed”
⚠️ “Pending”
🧮 4. Number/Date Filters
📅 Filter sales made in Last 7 Days
💵 Filter revenue greater than ₹10,000
Use these for dashboards, reports, and monthly insights.
🔄 5. Clear Filters or Sorting
🚫 Click Clear Filter from the header dropdown
🧽 Or use Sort & Filter → Clear (on the Home tab)
📝 Summary Table
| Feature | Use Case |
|---|
| 🔼 Sort A-Z | Names, alphabetical data |
| 🔽 Sort Z-A | Scores, numeric rankings |
| 🔍 Filter | View specific categories/items |
| 🔁 Multi-level Sort | Organize large structured reports |
| 📆 Date Filter | Filter reports by month/week |
💡 Pro Tips:
⚙️ Always convert your data into a Table (Ctrl + T) for advanced filtering & styling
🧠 Combine Sorting + Conditional Formatting for visual data highlights
🔒 Make sure you don’t sort only a column — select the entire table range!
Login to see the link
Login to see the link
