🔹 AutoFilter kya hai?

AutoFilter Microsoft Excel ka ek useful Data Management tool hai, jiska use large data mein se required records ko quickly display karne ke liye kiya jata hai.

Jab AutoFilter apply karte hain, to table ke column headings ke paas Drop-down arrow (▼) aa jata hai. Is arrow ki help se hum apni requirement ke according data ko filter kar sakte hain.

👉 Simple words mein:

AutoFilter ka use unwanted data ko temporarily hide karke sirf required data ko display karne ke liye hota hai.

📊 Simple Example

Maan lijiye student data hai:

Agar humein sirf Delhi ke students dekhne hain, to City column par AutoFilter laga kar Delhi select kar sakte hain.

Result:

Baaki records delete nahi hote, sirf temporarily hide ho jate hain.

🔹 AutoFilter kaise lagaye?

Method 1: Data Tab se

1. Apne data ke andar kisi bhi cell par click karein.
2. Data tab par jayein.
3. Filter option par click karein.
4. Har column heading ke paas ▼ arrow appear hoga.
5. Required column ka arrow click karein.
6. Required value select karein.
7. OK par click karein.

⌨️ Shortcut Key

Excel mein AutoFilter ko on/off karne ke liye:

Ctrl + Shift + L

Ye shortcut bahut useful hai.

🔹 AutoFilter se kya-kya kar sakte hain?

1. Text Filter

Names, cities, departments etc. ko filter kar sakte hain.

Example:

City = Delhi

Sirf Delhi ke records display honge.

2. Number Filter

Numbers ke basis par filter laga sakte hain.

Example:

Marks > 80

Sirf 80 se zyada marks wale students show honge.

3. Date Filter

Dates ke according data filter kar sakte hain.

Example:

Date = September 2026

Sirf September 2026 ke records display honge.

4. Multiple Filters

Ek se zyada columns par filter bhi laga sakte hain.

Example:

City = Delhi
AND
Marks > 80

Isse sirf Delhi ke woh students show honge jinke marks 80 se zyada hain.

🔹 AutoFilter ke Important Options

AutoFilter mein data type ke according different options milte hain:

Text ke liye:

• Equals
• Does Not Equal
• Begins With
• Ends With
• Contains

Numbers ke liye:

• Equals
• Greater Than
• Less Than
• Greater Than or Equal To
• Less Than or Equal To
• Between

Dates ke liye:

• Today
• Yesterday
• Tomorrow
• This Week
• This Month
• Last Month
• Next Month

📊 Practical Example – Sales Data

Agar humein Delhi ke Electronics products chahiye:

City → Delhi

और

Category → Electronics

Result:

🔄 AutoFilter Remove kaise karein?

Kisi ek column ka filter remove karna:

Column ke ▼ arrow par click karein → Clear Filter select karein.

Saare filters remove karna:

Data → Clear

Ya Filter ko completely off karne ke liye:

Data → Filter

🎯 AutoFilter ke Practical Uses

AutoFilter ka use bahut saare professional tasks mein hota hai:

• 👨‍🎓 Student records filter karna
• 💰 Salary records dekhna
• 📊 Sales data analyze karna
• 📦 Inventory check karna
• 👥 Employee records filter karna
• 📅 Date-wise transactions dekhna
• 🏢 Department-wise employees find karna
• 🛒 Product-wise information check karna

⚠️ Important Point

Filter data ko delete nahi karta.

Filter lagane par unwanted records temporarily hide hote hain. Filter clear karne par woh records dobara visible ho jate hain.