Formulas Paste Microsoft Excel ke Paste Special feature ka ek important option hai. Iska use tab kiya jata hai jab kisi cell ya range mein available formulas ko doosri location par copy karna ho.
Normal copy-paste mein formula ke saath formatting bhi transfer ho sakti hai. Lekin Paste Special → Formulas ka use karke hum mainly formula/calculation ko transfer karte hain aur destination cells ki existing formatting ko preserve kar sakte hain.
Jab kisi cell mein formula hota hai, Excel us formula ke basis par result calculate karta hai.
Example:
=B2*C2
Agar B2 mein 10 aur C2 mein 50 hai, to result 500 hoga.
Agar is cell ko Formulas Paste kiya jata hai, to destination mein 500 ki fixed value nahi jaati, balki formula transfer hota hai.
Formula → =B2*C2
Isliye destination cell bhi calculation perform karega.
Advanced Excel mein formulas ko baar-baar manually type karna time-consuming ho sakta hai. Formulas Paste ki help se existing calculation ko quickly reuse kiya ja sakta hai.
Ye particularly useful hai jab:
Maan lijiye ek sales report mein Total Amount calculate karne ke liye formula hai:
=B2*C2
Jahan:
Agar D2 ka formula doosri cells mein use karna hai, to formula copy karke Paste Special → Formulas ka use kiya ja sakta hai.
Excel destination ke cell references ke according formula adjust kar sakta hai.
| Formulas Paste | Values Paste |
|---|---|
| Formula paste hota hai | Sirf result paste hota hai |
| Calculation continue hoti hai | Formula remove ho jata hai |
| Dynamic reports ke liye useful | Fixed/final data ke liye useful |
| Cell references important hote hain | Cell references ki dependency nahi hoti |
Example:
Original cell:
=B2*C2 → ₹5,000
Formulas Paste: =B2*C2
Values Paste: ₹5,000
Formulas Paste ka use practical business work mein kiya ja sakta hai:
Leave a Reply