5. SORTING DATA

👇 Watch & share if you love this content!

🖥️ Check this out: Pivot Table - Sorting

---

🔢 5.1 - Sorting by Largest or Smallest 🔼🔽

நமக்கு sales figures இருக்குது அப்படின்னா,
🎯 Largest to Smallest or Smallest to Largest sort பண்ணலாம்.

📍Right-click → Sort → Largest to Smallest
இப்ப நம்ம top-performing items list ஒரே click-ல் ready! 💰

---

⬅️➡️ 5.2 - Sort an Item Row (Left to Right)

Usual sorting vertical-ஆ இருக்கும்,
But Pivot Table-ல horizontal headers-ஐ Left to Right sort பண்ணனும் நினைச்சா?

🧭 Go to Pivot Table → Design → Report Layout
Then:
👉 Right-click on column heading → Sort → A to Z (or Z to A)

Easy-a row headers-ஐ arrange பண்ணலாம்!

---

✋ 5.3 - Sort Manually (Drag, Write, Right Click)

Sometimes we want full control 😎
Excel gives us manual sorting options:

✅ Drag & Drop item in desired position
✅ Type in custom order manually
✅ Or: Right-click → Move → Up/Down/Beginning/End

அதிக freedom…நம்ம taste-க்கு match பண்ண sorting 😍

---

🧾 5.4 - Sort Using a Custom List

Ex: Weekdays as Mon, Tue, Wed… sort பண்ணணும்?

👉 Go to File → Options → Advanced → General → Edit Custom Lists
Add your custom order. Then:

🎯 Right-click Pivot Table → Sort → More Sort Options → Use custom list

Boom! Now Excel follows YOUR order 🧙‍♂️

---

🚫 5.5 - Override a Custom List Sort

Sometimes default custom list gets in the way 😤
No worries!

📍 Go to Sort Options → Uncheck “Sort using custom list”
Then choose manual or normal A-Z / Z-A sorting

Excel will forget your old custom order and follow your new one 👌

---

🔁 5.6 - Sort Row A-Z & Sales Z-A

Let’s say:

📦 Product Names - A to Z
💸 Sales Figures - Z to A

In Pivot Table:

🎯 First, sort row labels A-Z
🎯 Then, sort values (like sales) Z-A

Mix & Match possible for next-level clarity 💎

---

🆕 5.7 - Sort New Items Added to Data Source

New data added? 🤯
Excel won’t auto-sort unless you tell it to!

✅ Refresh Pivot Table (Right-click → Refresh)
✅ Then re-apply sorting

Now new rows/columns fall into sorted place automatically 📈✨

---

🧹 5.8 - Clear a Sort

Too much sorting confusion? 🤯 Clear it all!

🧽 Right-click on item → Sort → Clear Sort

Pivot Table will go back to original unsorted view. Fresh start! 🧼

---

🔝 5.9 - Sort Largest to Smallest Grand Totals

நமக்கு total sales per product தெரியணும் அப்படின்னா:

👉 Click on Grand Total column
👉 Right-click → Sort → Largest to Smallest

Top-selling products get spotlight 🌟
Bottom performers? We’ll fix them later 😅

---

🔚 Final Tips 💡

✅ Always refresh Pivot Table after data update
✅ Use filters + sorting for laser-focused insights
✅ Manual + Custom Lists give ultimate control 🔧
✅ Try out combinations to see what suits your data best 🎨

---

🎉 Hope this helps you become a Pivot Table Sorting Ninja 🥷
Any doubts or examples you want? Comment below! 👇💬