1. Sorting kya hai?

Sorting Microsoft Excel ka ek important data management feature hai. Iska use data ko kisi particular order mein arrange karne ke liye kiya jata hai.

Sorting ki help se hum data ko Ascending ya Descending order mein arrange kar sakte hain.

Example:
Agar students ke marks hain:

65, 40, 90, 55, 75

Sorting ke baad:

Ascending: 40, 55, 65, 75, 90
Descending: 90, 75, 65, 55, 40

2. Sorting ka use kahan hota hai?

Sorting ka use:

• Student marks arrange karne mein
• Student names alphabetically arrange karne mein
• Sales data organize karne mein
• Product prices arrange karne mein
• Employee salary records mein
• Date-wise records arrange karne mein
• Highest/lowest values identify karne mein
• Large datasets ko organize karne mein

3. Ascending Order

Ascending Order mein data small se large ya A se Z ki taraf arrange hota hai.

Numbers:

10 → 20 → 30 → 40 → 50

Text:

A → B → C → D

Dates:

Oldest → Newest

4. Descending Order

Descending Order mein data large se small ya Z se A ki taraf arrange hota hai.

Numbers:

50 → 40 → 30 → 20 → 10

Text:

Z → Y → X → W

Dates:

Newest → Oldest

5. Excel mein Sorting kaise karein?

1. Apne data table mein kisi cell ko select karein.
2. Data tab par click karein.
3. Sort & Filter section mein jayein.
4. Sort A to Z ya Sort Z to A select karein.
5. Excel data ko selected column ke according arrange kar dega.

Example – Student Report

Marks – Largest to Smallest:

6. Multiple-Column Sorting

Excel mein ek se zyada columns ke basis par bhi sorting ki ja sakti hai.

Example:

Pehle Class ke according sorting aur uske andar Marks ke according sorting.

Is tarah Excel mein primary level aur secondary level sorting ki ja sakti hai.

7. Sorting ke Important Points

• Sorting se original data reorder hota hai.
• Numbers ko ascending/descending order mein arrange kiya ja sakta hai.
• Text ko A–Z / Z–A arrange kiya ja sakta hai.
• Dates ko oldest-to-newest ya newest-to-oldest arrange kiya ja sakta hai.
• Multiple columns par sorting apply ki ja sakti hai.
• Sorting large datasets ko organized aur easy-to-analyze banati hai.