Monday, June 1, 2020

PASTE SPECIAL KI SABHI JANKARI FOR EXCEL EXPERT


Chaliye Dosto Aj Me Apko Copy Ke Bad Ka Option Samjhata Hu Matlab Paste Special Ka, To Chalye Bina Time Gawaye Shuru Karte Hai Dosto Ap Sabko Ye To Pata Hi Hogaki Copy Ke Bad Paste Kya Jata Hai But Kya Apko Ye Pata Hai Advance Tarike Se Kese Paste Kya Jata Hai Matlab Paste Special Option Ka Use Kese Kya Jata Hai To Chlye Bina Time Gawaye Shuru Karte Hai To Sabse Pahle Hum Kuch Copy Kar Lete Hai Aur Ab Ise Paste Special Karte Hai

Paste Special Ka Inbox Dekh Lo Dosto Ki Hota Kesa Hai

 

Ye Paste Special Ka Box Jisme Bahut Se Option Hai Jiske Bare  Me Main Aap Sabhi Ko Bataunga To Chalye Shuru Karte Hai Series Wise Pahle Option Me “All” He  Ye Sab Kuch Paste Karta Hai  Is Tarah Se

Computer Is An Device                    Computer Is An  Device

Second Option Me Hai Formulas Ye Sirf Formulas Ko Hi Paste Karta Hai Koi Format Ko Nahi

Jese :-

                        =2+2                 =2+2

Agla Option Hai Value Ye Sirf Value Hi Paste Karta Hai Ye Formulas Break Kar Deta Hai Aur Koi Format Paste Nahi Karta Hai Is Parkar Se

                         =2+2                 4

Agla Option Ata Hai Formats Ka Ye Formats Paste Karta Hai Jab Isi Parkar Ka Format Kisi Pe Apply Karna Ho To Ise Hi Use Karo Jese

Computer Is An Electronic Device            Microsoft Office Excel

Ye Dekho Ho Gaya Na Isi Tarah Se Ham Iska Use Karte Hai  

Agla Option H Comment Ka Ye Option Tab Use Karte Hai Jab Kisi Me Comment Dya Hua Hai Aur Same Wohi Comment Hame Kahi Aur Bhi Dalna Hai To Is Option Ka Use Karne Chahiye

 Validation Ka Use Tab Kya Jata Hai Jaha Pe Data Vallidation Apply Hua Ho Is Option Se Wahi Validation Copy Ho Jata Ha Is Tarah Se

 

  Agla Hai All Using Source Me Ye Option Me Sab Kuch Paste Ho Jata Hai Chahe Wo Format Ho Ya Kuch Aur Hi Ku Na

Next Hai All Except Border Is Option Me Sab Paste Ho Jata Hai Siway Border Ke Is Tarah



         

Agla Hai Column Width Option Use Dosto Isme Column Ka Size Paste Kya Jata Hai Is Tarah                                     

 

Same Paste Ho Jata Hai

Agla Hai   “Formulas And Number Format”    Isme Number  , Ya Text Ho Ya Formulas Ho Sab Paste Hota Hai Siway Format Ke

Agla Hai  "Value Aur Number Format"  Isme Sirf Number Aur Value Hi Paste Hota Ha

To Dosto Ye Main Option The Jo Maine Ap Sabhi Ko Bata Dye Ise Use Jarur Kariye Bahut Kam Ke Hai

 


DOSTO YE CLASS CONTINUE JOIN KARTE RAHO AUR SABHI KO YE FREE CLASS KE BARE ME BATAO TAKI SABHI  SIKH SAKE AUR KOI PROBLEM ATI HE TO MUJHE COMMENT JARUR KARNA  (PLS 🙏🙏SHARE KARNA AUR MUJHE FOLLOW JARUR KARNA )


APKA MERE PAGE PE ANE KE LYE DHANYAWAD 🙏🙏🙏🙏 

LINK :- ADVANCEBANO.BLOGSPOT.COM
BY-AAKASH

1 comment:

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...