The options available include Keep Source Formatting (maintain original font type and size of copied text), Match Destination Formatting (change the font type and size of pasted text to match the existing document), Keep Text Only (text only just as it’s been typed, discarding everything else) and also ability to let you apply your desired style or formatting.Īlternatively, the manual formatting of the text block can be removed when copying and pasting by using Word’s Paste Special feature. The Word formatting options will be prompted when the text block been pasted and appeared as expandable icon. To solve the problem of different font type and font size when copying and pasting from other documents, newer version of Microsoft Word such as Microsoft Office Word 2003, Word 2007, World 2013 and Word 2016 has built-in functionality to let users to choose the style or formatting that they want to apply to the text block that is been pasted.

Step1: open your excel workbook and then click on “ Visual Basic” command under DEVELOPER Tab, or just press “ ALT+F11” shortcut.When you copy and paste a block of text into Microsoft Office Word document from external source or third party documents such as web browser or another documents, the existing hidden formatting from the external documents on the pasted text block will also be pasted into the existing Word document, thus affecting the size or font, or have the different size or font from the existing document. You can also use a VBA Macro to always default match destination formatting when you press Ctrl + V keys on your keyboard. Step5: click Ok button, and the Paste and Match Destination Formatting button should be added to the Quick Access toolbar.Īlways Match Destination Formatting with VBA Macro Step4: choose Paste and Match Destination Formatting command and click Add> button to add this command to the Customize Quick Access Toolbar. Step3: in the “ Choose commands from:” dropdown menu, select “ All Commands“. Step2: click “ Customize Quick Access Toolbar…” and the Excel Options dialog will open. Step1: right click on the Quick Access Toolbar (the area in the top left with the Save, Undo and Redo buttons) You can add “Paste and Match Destination Formatting” command to Quick Access Toolbar, when you copy and paste data to your worksheet, just easily click Match Destination Formatting button on the Quick Access Toolbar.

Always Match Destination Formatting with VBA Macro Always Match Destination Formatting with Paste and Match Destination Formatting command.Always Match Destination Formatting with Paste and Match Destination Formatting command.

Keep source formatting word 2013