Excel sheet main duplicate rows ya entry kaise delete karain




Excel sheet main duplicate rows ya entry kaise delete karain: Excel sheet main duplicate rows ya entry kaise delete karain: Dosto aaj ham aapko batayenge ki Excel sheet main yadi aapko kuchh aisee entries hain jinko delete karna hai to kaise delete karainge jis se ki aapka data filter ho jaye aur uss excel sheet main koi bhi duplicate value na bache, to dosto uske baare main ham aapko neeche batane ja rahae hain ke Excel sheet main duplicate rows ya entry kaise delete kar saktey hain.

Excel sheet main duplicate rows ya entry kaise delete karain

Step 1:-

Dosto ye bahut hee aasaan hai iske liye bas aapko ye karna hai ki sabse pehle jis sheet main aapko duplicate rows ya duplicate data ko delete karna hai usko open kar lain ab Excel sheet main Data wale tab par click karain tab aapko Remove Duplicates ka option dikhayee de jayega jaisa ke aap neeche wali image main dekh saktey hain.

Excel sheet main duplicate rows ya entry kaise delete karain

Step 2:-

Ab neeche diye huye sheet ke jaise sheet main jo left hand ki taraf red box se hamne select kiya hai aapko bhi theeek waise hee aise column main jis main ke aap duplicate value ko delete karna chahtey hain select kar lain aur fir ooper wali image main diye huye Remove duplicate wale tab par click karain, uske baad aapko ek window dikhayee degi jaisee ke neeche wali image main right hand side main dikhayee de rahe hai usmain aapko errow ke nishaan wale redio button (Continue with the current selection ko select karne ke baad Remove Duplicates…. wala button ko click karna hai.




Excel sheet main duplicate rows ya entry kaise delete karain

 

 

 

Step 3:-

Ab aap neeche wali image main dekh saktey hain ke aapko iss screen main kuchh nahi karna hai sirf ok par click karna hai.

Step 4:-

Ab aap payenge ke iss image main Sr. no. 3,4,5,6, aur Sr. no. 7,8,9,10 duplicate hain.aur ok ka button click kartey hee excel sheet se apne aap duplicate data delete ho jayega.




Excel sheet main duplicate rows ya entry kaise delete karain

 

 

 

Agar aap chahe to 1 column ki jagah kuchh rows ya kuchh column ya fir Ctrl+A karke poori sheet select karke usmain se duplicate data ko delete kar saktey hain.




Dosto main ummeed karta hu ke aapko hamaree ye post Excel sheet main duplicate rows ya entry kaise delete karain bhee kaafi pasand aayi hogi.

Aur agar aap koi aur sawaal ham se poochhna chahtey hain to hame comment box main likhkar poochh saktey hain.

aap hame subscribe bhi kar saktey hain.

 

Thanks ……. Shukriya….    !!!!

4 thoughts on “Excel sheet main duplicate rows ya entry kaise delete karain

Leave a Reply

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