MS EXCEL CLIPBOARD GROUP
Aapne jayadatar dekha hoga ki Excel mein kaam karte waqt hum sabse zayada kya karte hain? Copy aur Paste! Lekin kya aapko pata hai ki Home Tab ka sabse pehla hissa, yaani clicpboard Group sirf normal copy-paste se khin zayada kaam kar sakta hai. to aap hum sikhege ki ms excel me home tab ke cliboard ke bare mein.
Clipboard Group :-
Ms Excel mein sabse phle aapko clipboard dekhne ko milta hai. Isme Cut , Copy , Paste toh hai he leikn sabse kaam ka hai to vo hai Format Painter.
1. CUT:- Iska kaam hai data ko ek jagah se hatakar dusri jagah move karna . jab aap kisi cell ko 'Cut' karte hain, toh wo wahan se gayab hoakr "Paste "waiting mein rahta hai.text copy karne ke liye hum Ctrl+C ka use karte hain.
2.COPY:-Agar aap chahte hain ki data purani jagah bhi rahe aur nayi jagh bhi aa jaye, toh 'COPY' use karein. Isse aapka original data safe rhata hai. Copy karne ke liye Ctrl +C ka use karte hai.
3. PASTE :
Copy ya Cut kiye gaye data ko insert karne ke liye Paste ka istemal kiya jata hai. Lekin Excel mein "Paste Special " ka bhi option hota hai, jisse aap sirf ' Values' ya sirf 'Formulas' bhi paste kar skte hain.
4. FORMAT PAINTER:-
Ms excel ka ye feature kaafi fayde wala hai kyoki yadi aap koi bhi formating karte hai jese Bold, Italic,ya baground change kiya hai to aap ye same design dusre 10 cells par chahte hain.
- Sbse phle purane cell par click kare.
- Format Painter par click karein.
- Ab naye cells par brush ki taraf fer dein.aap dekhnge ki saara design bina mehnat ke copy ho jayega.
CONCLUSION
Toh doston, umeed hai ki aap samajh gaye honge ki MS Excel ka clicpboard group sirf copy paste tak simit nahi hai . Format painter aur Clipboard pane jaise tools aapka kaam na sirf aasan banate hai , balki aapka bahut saara samay bhi bachate hain.
0 Comments