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

  • 26/05/2016 at 3:01 PM
    Permalink

    bhai mujhko ye batao ki transport company me data ko entry kaise karenge …plz. bhai puri jankari dijiye ………. mera email hai mv201696@gmail.com hai

    Reply
    • 28/05/2016 at 10:36 PM
      Permalink

      Dost main aapki problem ko samajh nahi paaya hu ki aap kya poochhna chahtey hain kyuki koi bhi company ho chahe wo transport company ha ya koi bhee doosri company ho ham log Excel sheet ka prayog kartey hain isse hame kisi bhi prakaar ki calculation karne main bahut aasani ho jaati hai iske alawa excel main aise bahut saare features hain jinke istemaal se aap kisi bhi prakaar ke data ko bahut hee acchhe se manage kar saktey hain yadi aap ko excel ka acchha gyan hai to excel ke features ka use karke aap bahut hee aasaani se kar saktey hain.

      Reply
      • 05/06/2016 at 11:24 PM
        Permalink

        Dost mujhe ye bataye ki data ko entry kaise Karen , aur sath me ye bataye ki data ko print karne pe usme grid line na aaye

        Reply
        • 06/06/2016 at 1:31 PM
          Permalink

          Dost aap excel main View Tab par click karna hai uske Andar jaakar usmain ek option hota hai gridline ka usko tick aur untick karne ka, aap usmain jaakar untick kar dey aapki gridline nahi print hongi.

          Thnaks

          Reply

Leave a Reply