posacare.blogg.se

And then save and close this dialog, then press Alt + F8 keys to open the Macro dialog. VBA code: Set Match Destination Formatting as the default paste Sub PasteWithDestinationFormatting()ģ. Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ.

You can also set the Match Destination Formatting as the default paste option when you using Ctrl + V with the following VBA code.ġ. Note: This method is not applied to Excel 2007. And now, the Paste and Match Destination Formatting has been added to the Customize Quick Access Toolbar, see screenshot:Īnd when you paste the data from other application, you just need to click the Paste and Match Destination Formatting button in the Quick Access Toolbar, the content will be pasted to the sheet matching the destination formatting of your worksheet. After adding this command, then click OK button to close this dialog box.ģ. (4.) Then click Add > button to add this command to the Customize Quick Access Toolbar.Ģ.(3.) And then scroll down and choose Paste and Match Destination Formatting in the list box.(2.) Then choose All Commands under Choose commands from drop down list.(1.) Click Quick Access Toolbar in the left pane.Click File > Options, and in the Excel Options dialog box: To make Excel paste the data with destination formatting, you can add a special command to your Quick Access Toolbar.ġ. Paste external content to worksheet always match destination formatting with VBA code Paste external content to worksheet always match destination formatting with Excel Options But, if you need to apply this option frequently, I can help you set this option as default when you using Ctrl +V to paste data. If you need the pasted data using the own format of your used worksheet, you should choose Match Destination Formatting option to your need when you paste. When copy and paste data from other external applications to worksheet, Excel will paste the data with the original formatting it used by default. How to paste external content to Excel always match destination formatting?