(Your newly created macro should be among them.) Excel displays the Macro dialog box, which includes a list of your defined macros. Once your macro is set up, you can replace the regular Ctrl+V command by following these steps: Here are the Excel docs that explain the modes available: You can modify the value of the Paste parameter to be something different, if you find a different pasting mode is better for your purposes. If you want to take the macro route, you can create a very short macro like the following:ĪctiveCell.PasteSpecial Paste:=xlPasteValues Now when you want to paste, you can simply click on the newly added tool and you will have the desired effect in your worksheet. Click OK to close the Excel Options dialog box.The command moves to the right side of the dialog box. Scroll through the Commands list until you find 'Paste and Match Destination Formatting' option.Using the Choose Commands From drop-down list, choose All Commands.The Quick Access Toolbar option in the Excel Options dialog box. At the left side of the dialog box click Customize (Excel 2007) or Quick Access Toolbar (later versions of Excel).In Excel 2010 or a later version display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. In order to take this approach, the cleanest approach would be to add the desired paste mode to the Quick Access Toolbar. However, you may want to consider a non-macro way, as well. Yes, there is a way to change the default using macros. Avner wonders if there is a way to change the default paste format to match the destination format. But 99% (it is probably 99.99%) of the time, he wants to use the destination worksheet's format, so he needs to change the paste option to 'Destination' format.

Avner notes that when he copies information from an external source, the default 'paste' is to match the origin's format.

How to change excel default settings