Have you ever struggled with modifying your Excel document while on the go? Well, DocHub comes with an excellent solution for that! Access this online editor from any internet-connected device. It enables users to Paste scuff in Excel files quickly and whenever needed.
DocHub will surprise you with what it provides you with. It has robust capabilities to make any updates you want to your forms. And its interface is so easy-to-use that the entire process from beginning to end will take you only a few clicks.
Once you finish editing and sharing, you can save your updated Excel file on your device or to the cloud as it is or with an Audit Trail that contains all adjustments applied. Also, you can save your paperwork in its initial version or convert it into a multi-use template - complete any document management task from anywhere with DocHub. Sign up today!
in this video well learn how to work with the paste special using the macro spot now for example if I have some data on the screen if you see theres a a column and B column here if I want to only paste the formats from the a column into B column how do I work on that normal paste will not work copy paste will not work I have to use the paste special option what you do is usually you select this data like this okay and then you copy this Ill click on copy and if you want to paste the formats here what you do is you just right-click on this place like this and you can click on the space special dialog box so once you click on that paste patient you get this dialog box from here you select different options like say example formats you select as comments validation and so on whichever options you want you can keep on selecting from here lets see if I want the formats if I click on OK so formats from this cell Ive been copied and into pasted into the P column itself so this is wire