ADVANCE EXCEL

Microsoft Excel Me Data Sort Filter Ka Use Kaise Kare

Ramesh Singh

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.

Iss function mein basically 5 tabs highlighted hote, jaisa ki upar image mein dikhaya gaya hai, to chaliye dosto jante hai sort & filter ke inn 5 tabs ke baarey mein detail sey.

SORT SMALLEST TO LARGEST (A TO Z)

Data sort filter function ke undar sort A to Z ki help se hum data ko ascending order mein sort kar sakte hai, agar hum alfa ko sort karte hai to yeh A to Z Yani ki jo word ya character A letter se start honge unko sabse uppar kar dega aur jo letter Z se start hote hai, unko sabse niche ki orr kar dega, thik issi tarah ye function numeric ko bhi assending karta hai yani ki num 0 se 9 badhte karam me sort karta hai. Image dekhein.

STEP 1

Sabhi text list ko select kare.
 
 

Step 2

A to Z par click kare.

Step 3

After click A to Z ke baad ka result dekhe.

Issi tarah se hum numeric ko bhi ascending order mein sort kar sakte hain. see image

Step 1

Numeric select kare.

Step 2

[A to Z] par click kare.

Step 3

A to Z par click karne ke baad numeric sort ho jayege.

SORT LARGEST TO SMALLEST (Z TO A)

Sort Z to A ki help se hum data ko discending order mein sort kar sakte hai, agar hum alfa ko sort karte hai to yeh Z to A Yani ki jo word ya character Z letter se start honge unko sabse uppar kar dega aur jo letter A se start hote hai, unko sabse niche ki orr kar dega, thik issi tarah ye function numeric ko bhi discending order me karta hai yani ki num 9 se 0 ghatatey karam me sort karta hai. Image dekhein.

Step 1

Saare text ko select kare.

Step 2

A to Z ki button par click kare.

SORT

Sort function ka use excel me mostly table ko sort karne ke liye kiya jata hai, isski help se hum table ko alag alag coloumn ke hisab se sort kar sakte hai vo bhi bina data hilaye. chaliye dekhte hai kaise.

Step 1

Sabse pehle for example ek salary list ki table banaye aur phir table ko select karein. image dekhe.

Step 2

Iske bad sort function par click kijiye, aapke samne sort level set karne ka ek box khulega, jiske hisab se aap sort ko set kar sakte hai. Image dekhe.
Iss box ke top me kuch functions diye huye hai, chaliye jaantey hai unke barey me.
Add Level
Add level se hum data sort karne ke liye ek se jyada conditions laga sakte hai, jitne baar iss function par click karte hai to niche grid me utni baar level judte chale jate hai, image dekhe.
 
 

Delete Level

Delete level se hum saary sort level ko remove kar saktey hai, image dekhein.

Copy Level

Copy level ki help se hum first level ko same niche add kar sakte hai, jo conditions pehle level pe hogi vo niche repeat ho jayegi. image dekhe.

Options

Options ki help se different options set kar sakte hai, jaise ki 1> case sensitive 2>sort top to bottom 3> sort left to right. image dekhe.

My Data Has Headers [Tic Box]

Iss option ki help se hum sort by ki field me header ko add ya remove kar sakte hai.
Tick ke sath image dekhein.
Without tick. image dekhein.
Column, Short By

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

Ek table banaye aur usko select karein.

 

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

Shortcut:-  Ctrl+Shift+L
Filter se hum kisi bhi list ya table me data ko filter karke show kar sakte hai, aur jo filter ki condition hum set karte hai uske according yeh function data show karta hai. Chaliye dekhte hai kese.

 

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.

 

Step 2

Heading me jo dropdown hai uspe click karne se filter ke options khul jayenge, image dekhe.

 

Dropdown me Sort A-Z, Sort Z-A aur Sort By Color ke baarey me aapko upar bata chuka hu,

 

TEXT FILTERS

Equals

Step 1

Dropdown ko open kare aur text filters me equals pe click kare.

 

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

Iss filter se hum do names ko bhi ek sath filter kar sakte hai. iske liye equals par click kare aur left side ke dono box me equals set kare, iske baad right side ke dono box me vo names select kare jinhe filter karna hai. image dekhe.

 

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.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

3 thoughts on “Microsoft Excel Me Data Sort Filter Ka Use Kaise Kare”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.