Excel main kuchh kaise dhhonde ya find kare aur replace kare




Excel main kuchh kaise dhhonde ya find kare aur replace kare: Dosto aaj main aapko batane ja raha hu ki microsoft excel ki kisi sheet main agar aapko kuchh dhhoondna hai ya search karna hai ya find karna hai to kaise find karenge aur agar hame kuchh replace karna hai to kaise replace karenge.

Friends Microsoft excel ek bahut hee mazerdaar cheez hai ismain ham aise bahut saare kaam kar saktey hain jo ki agar manual kiye jaye to bahut hee mushkil hoga aur yahi kaam agar excel sheet main kiya jaye to bahut hee kam samay main chutkiya bajatey hee ham ye kaam kar saktey hain.

Excel main kuchh kaise dhhonde ya find kare aur replace kare-

Step 1-

Excel main kuchh kaise dhhonde ya find kare aur replace kare:

Dosto aap ko bas itna karna hai ke jaise hee aap apnee excel sheet main Home jo ulte haath ki taraf sabse oopar wala tab Home Tab hai by default excel main ye tab khula hua hee hota hai. Aur jab aap right hand ki taraf Find & Replace wale tab par click karenge to aapko neeche dikhayee de rahee screen dikhayee degi usmain aapko Find ya fir replace wala tab choose karna hoga, main to suggest karunga ke aap replace ko choose karain kyuke replace ko choose karne par jo window khulti hai usmain find aur replace dono ka option hota hai.

Excel main kuchh kaise dhhonde ya find kare aur replace kare-

Step 2-




Excel main kuchh kaise dhhonde ya find kare aur replace kare 1

Aur jab aap jaisa ki oopar wali image main right hand ki taraf jo errow dikhayee de raha hai Find,  Replace uss Find ya Replace waley tab par click karenge to aap ke saamne neeche wali window dikhayee degi.

Excel main kuchh kaise dhhonde ya find kare aur replace kare-

Step 3-

Dosto main aapko iski ek shortcut key bhi bata raha hu Find & Replace ki screen direct kholne ke liye wo hai ( Ctrl+f ) apne keyboard main aap Ctrl key ke saath agar f ko dabayenge to ye neeche wali screen aapko dikhayee degi.

Excel main kuchh kaise dhhonde ya find kare aur replace kare 3

Jaisa ki aap ooper wali screen main dekh rahe aapke saamne ye screen khul jayegi jismain 2 option aapko oopar dikhayee denge pehla Find aur doosra replace.

Agar aap apni excel sheet main kuchh search karna chahtey hain ki wo kaha kaha par hai to aap Find tab ko select kar lain uske baad uske neeche jo Find what: ka box dikhayee de raha hai waha par jo aapko find karna hai likh dijiye aur find next par click kare to aapko 1 by 1 find karke dikha dega aur agar aap find aal wala click kartey hain to ek baar main hee sab search karke bata dega.

Excel main kuchh kaise dhhonde ya find kare aur replace kare-

Step 4-

Dosto agar aap koi bhi text ya kuchh bhi jo aapki Microsoft Excel ki sheet main hai usko change karna chahtey hain ya replace karna chahtey hain kisi aur word ya shabd ya sankhya se to Replace wale option se kar satey hain.

Excel main kuchh kaise dhhonde ya find kare aur replace kare 2

Aapko bas itna karna hai ki jaisa ki aap oopar wali screen main dekh rahe ahin aapko Repalce wale tab par click karna hai uske baad aapko Find what: wale box main wo likhna hai jisko app replace ya badlna chahtey hain usske baad aapko Replace with: wale box main wo likhna hai jisse ki aap uss text ko change karna chahtey hain.

For example: agar aap apne sheet main se jitne bhi , (comma) hai aur aap chahtey hain ki aap unko hata de to aap Find what wale box main type karain aur fir Replace with: wale box ko khali chhod de aur Replace ya Replace All wale button par click karain. Appki sheet main jaha bhi  waha se , (comma) hat jayega.




Aur agar aap chahtey hain ki jaha jaha par bhi , (comma) laga hai waha par – (Dash) lag jaye to Replace with wale box main – sign type kare aur Find what wale box main , (comma) type karke Replace ya replace all wale button par click karain.

Dosto aap chahe to kisi text ya number ya kuch bhi jo aapki sheet main he usko aise hee find kar saktey hain aur aasaani se replace bhi kar saktey hain.

Read this also: Excel sheet main duplicate rows ya entry kaise delete karain

Freinds main ummeed karta hu ke aapko hamara ye post Excel main kuchh kaise dhhonde ya find kare aur replace kare pasand aaya hoga.

Agar aap ko kuchh samajh nahi aaya ho ya aap kuchh aur jannana chahtey ho to aap hame comment box main likh kar poochh saktey hain. dosto aap hame subscribe bhee kafr saktey hain.

Aapka din shubh ho……. Dhanyawaad……..!!!!

2 thoughts on “Excel main kuchh kaise dhhonde ya find kare aur replace kare

  • 24/08/2016 at 10:32 PM
    Permalink

    dear sir.
    i want to know that.
    maan lo hamare paas do list h.
    ek me 10 naam h or dusri me 20 naam h.pahle list k 10 naam bhi dusri list me include.
    to pls ye bataaye ki me dusri list me pahli list k 10 naam ek sath kaise search karun.
    pls jaldi bataaye.

    Reply
    • 24/08/2016 at 11:59 PM
      Permalink

      1. sabsay phelay aap dono lists ko select kar lain.
      2. Home tab ke tool bar me aap ko conditional formatting per click karein
      3. Highlight cells rules per mouse ko lejaye
      4. Duplicate values ko select karein
      5. aap ko 1 dialog box dikhayee dega, yahana is dialog box me aap duplicate values konsay coler me show karna hai dropdown se select kar lain.
      6. Ok button per click karein. Aap ke duplicate values list dono list me heighlifht ho jayengi.
      yadi aap ki list lambi hai to aap baad me filter ka use bhee kar saktey hain.

      Reply

Leave a Reply

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