Using Paste Special To Copy Format, Formula, Values & its Shortcut Key In Excel In Hindi – Lesson 27



How To Use Paste Special For Pasting Format, Formulas, Values Etc. In MS Excel 2016/2013/2010/2007 ? How To Use Paste Special In MS Excel 2016 ? What is Keyboard Shortcut for Paste Special in Microsoft Excel 2016 ?

MS Excel 2016 Ke Iss Tutorial Me Aap Janenge MS Excel 2016 Me Paste Special Option Ka Upyog Karna. Excel 2016 Me Paste Special Option Ki Sahayta Se Formulas, Values, Formats Ityadi Ko Paste Karna. Microsoft Excel 2016 Me Paste Special Ki Shortcut Key.

MS Excel 2016 के…

19 thoughts on “Using Paste Special To Copy Format, Formula, Values & its Shortcut Key In Excel In Hindi – Lesson 27

  1. I want to apply multi functions in command button. i am fresher in excel and required codes to perform certain functions The functions to do with command button are as folllows.-

    1. Task for Print and save invoice button should be, it should save invoice details like invoice no., date, amount of different taxes i.e. tax1, tax2 etc., final amount after taxes, to table in sheet2. also the invoice should save in pdf and xlsx format in desired drive along with that, invoice should print simultaneously first

    I have tried using code for clear and new invoice which works perfectly but i need codes for print and save invoice button.
    codes for clear and new invoice i tried

    Private Sub CommandButton3_Click() Range("a10").Value = Range("a10").Value + 1 Cells(9, 5) = Date Range("c12:d31") = ClearContents
    End Sub

    Private Sub CommandButton2_Click()

    codes for print and invoice save invoice is required.
    ????
    please help in provinding codes for print and save invoice button.

    images for better understanding.

    https://www.sendspace.com/file/6b9lue

    https://www.sendspace.com/file/jd1wl0

  2. medam excel main ese kaise hota hai ki agar mere paas 5 gaav ke naam 1 gav main 50 consumer hai agar jim par kuch na kuch amount bakaya hai agar lakin sare gav ke naam mix hai agar main gav wise bakaya amount jan na chahata hu to main kaise karu. video dwara samzaye.

  3. हाय मैडम आप ये बताये की अगर हम अपने फोन से ईमेल कैसे भेजे और कैसे मालूम करे की कौन मेरे ईमेल आईडी पर मेल भेजा हे

Leave a Reply

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