how to keep source formatting in word 2010

Click on the Customize Quick Access Toolbar icon in the toolbar, and choose More Commands….To speed up the process described above, add the Paste and Match Destination Formatting icon to your Quick Access Toolbar in Excel. If you paste data using the shortcut CTRL + V, it will keep formatting from the source file. Choose Match Destination Formatting in the Paste Options.Īs a result, the Word data is pasted in Column C in Excel, keeping the Excel formatting.Then, right-click the cell where you want to paste data (here, C1).On the other hand, in the Word document, there are prices you want to paste in Excel, Column C.įirst, copy the data in the external application.

Say you have the following sales data set in Excel.Īs you can see, the range now has banded rows (blue and white), with Price and Total columns with the currency. When pasting data from an external application (Word, PowerPoint, or similar) to Excel, you can either keep the formatting from the source document or match the formatting in Excel.

This tutorial demonstrates how to paste and match destination formatting in Excel and Google Sheets.

How to keep source formatting in word 2010