Instructions to copy data from Excel to Word retain the format

Sometimes at work you want to convert table data from excel to word, but when the copy to word is formatted or exceeds the frame in the word. The following article details how to copy data from excel to word to keep the format.

Step 1: Open the Excel file containing the data to copy -> Highlight the data you want to copy -> Right-click and select Copy .

Instructions to copy data from Excel to Word retain the format Picture 1

Step 2: Open the Word file you want to insert data from Excel -> place the cursor at the position you want to paste -> on the HOME tab -> Paste -> Paste Special .

Instructions to copy data from Excel to Word retain the format Picture 2

Step 3: A dialog box appears, select Paste -> Microsoft Excel Worksheet Object -> OK .

Instructions to copy data from Excel to Word retain the format Picture 3

1. In case you want to paste quickly and keep the format

Right-click -> Choose the 1st, 2, 3, 4 . features of Paste Special .

Instructions to copy data from Excel to Word retain the format Picture 4

You can choose Paste to keep the format using features 1, 2, 3 . And you manipulate editing right on the pasted paste.

2. Get only the textual content to Paste

Select the 6th feature Keep Text Only (T) .

Instructions to copy data from Excel to Word retain the format Picture 5

3. Paste with image format and you can not manipulate, edit the data just pasted

Use the fifth Picture feature (U) .

Instructions to copy data from Excel to Word retain the format Picture 6

Above are some ways to copy data from Excel to Word hoping you will apply this feature often.

Good luck!