Microsoft excel me data sort filter ka use kaise kare aaj ki iss post me mein aapko batane wala hu. To agar aap excel me work karte hai aur data sort filter ke use ke bare me janana chahte hai. To iss post me mein aapko data sort filter ki puri jankari step by step bataunga. To chalilye shuru karte hai aur janate hai ms exce me data sort filter kaise use hota hai.
SORT SMALLEST TO LARGEST (A TO Z)
STEP 1
Step 2
A to Z par click kare.
Step 3
Issi tarah se hum numeric ko bhi ascending order mein sort kar sakte hain. see image
Step 1
Step 2
Step 3
SORT LARGEST TO SMALLEST (Z TO A)
Step 1
Step 2
SORT
Step 1
Step 2
Delete Level
Copy Level
Options
My Data Has Headers [Tic Box]
Column, Short By function se jis column ya jis heading ko short karna hai, choose kar sakte hai, iss function se jo column ya jo heading humne choose ki hai ussi ke according data short ho jayega.
Sort On
Sort on se hum 4 tarike se data ko sort kar sakte hai, [1]Values – Values se hum normal text ya numbers ko sort kar sakte hai. [2]Cell Color – cell color se hum cell ke background color ke hisab se sort kar sakte hai. [3]Font Color – font color se text ke color ke hisab se sort kar sakte hai [4]Cell Icon – agar cell me alag alag tarah ke icons lage honge to unke hisab se sort kar sakte hai.
Order
Yeh function Sort On function ke according kam karta hai, agar sort on selection me hai to:- [1] Values function me aapko order A-Z (ascending), Z-A (discending) aur customize list show karega, customise list me aap apne according condition set kar sakte hai. [2] Cell Color, aur [3] Font color ke liye aapko color ke liye puchega jis color se aapko sort karna hai set kar sakte hai, [4] Cell Icon table me jo icons honge unke according set kar sakte hai.
Chaliye dosto aapko step by step symple sort karke dikhate hai ki kese karte hai, baki other conditions aapko khud karke samajh me aa jayegi, jo conditions aapko upar bataye gaye hai.
Step 1
Step 2
Iske baad sort par click karke jiss heading ko sort karna hai usse select kare. For example humne sort by me EMP NAME heading ko select kiya hai, sort on me values aur order A-Z hai, iske baad niche OK button par click kare.
Step 3
Ab aap dekh sakte hai ki EMP NAME wala column ascending order me ho gaya hai. Issi tarah se aap dusri heading ko bhi sort kar sakte hai.
FILTER
Step 1
Sabse pehle worksheet me ek table ya list banaye, phir filter option par click kare, aap dekhenge ki neeche list ki heading me ek dropdown lag gaya hai.
TEXT FILTERS
Equals
Step 1
Step 2
Equals ke agle box me vo name select kare jisse filter karna hai, phir OK par click kare.
Step 3
Jo name aapne select kiya hai vo filter hokar samne aa jayega chahe vo ek baar ho ya ek se jyada baar.
Step 4
Step 1
Step 2
Does Not Equals
Iss filter ko apply karne se jo name aapne select kiya hai vo hide ho jayega aur uss name ko chhorr ke baki sare name show karenge.
Step 1
Step 2
Begins With
Yeh filter names ke pehle character se lagta hai jaise ki jiss name ka pehla character aapne select kiya hai vo hi name show hoga.
Step 1
Step 2
Ends With
Yeh filter bhi begins with ki tarah hi kaam karta hai fark shirf itna hota hai ki ye last ke characters se filter karta hai.
Contains
Iss filter ki help se hum kisi bhi list me koi perticular word ya character ko choose karke filter kar sakte hai, jaise ki niche image me names list ko contains filter “I” select kiya hai, jiske ki yeh “I” character wale names ko hi select karega. For example VIJAY name me “I” character hai, image dekhe.
Step 1
Step 2
Does Not Contains
Iss filter me aap jo characters ya word key karenge yeh uss name ko show nahi karega, balki unke alawa baki saarey words ya names ko show karega. Jaise maine character “M” ko select kiya hai.
Step 1
Step 2
Costome Filters
Costome filter ki help se hum apne according filter ko set kar sakte hai aur sath hi sath new filters ko b creat kar sakte hai.
Niche image me jo aapko name list dikh rahi hai agar unn sab par tick mark hai to hame saari name list show hogi, agar select all se tick mark hata denge to saarey names hide ho jayenge, aur agar kisi ek name pe tick mark karenge to shirf vahi name show karega.
Dosto ye to thi data short & filter ki jaankari hindi me, aapko yeh post kaisa laga iske baarey me aap mujhe comment kare jaroor batayein.
View Comments (3)
Very nice kai logo ki bohat jyada madat ho gi thanx bro
I like
thanks