When copying a table from Excel to Word, the formatting of the table may not match the formatting of the Word document. This can result in formatting issues, such as mismatched font sizes, colors, and spacing. Copying data without a table can help to avoid these issues. This post introduces a few ways to copy table from Excel data to Word without using a table.
Read More: Copy and Paste to Skip the Duplicate Values in Excel
Copy Table from Excel to Word without Table Formatting by Paste Special Feature
The “Special Paste” feature in Word provides several ways to paste data in different formats. Using the “Unformatted Text” or “Keep Text Only” methods can help us paste table contents without table formatting and structure.
Copy Table without Table Formatting via Paste Special -> Unformatted Text
Here are the steps:
1. Select the table in the opened sheet, press Ctrl+C to copy it. In this example, the copied table is B2:F7.
2. In Word, go to the location where you want to paste the data, right click and select Paste Special in the menu.
3. In Paste Special dialog, check on “Paste” option, and select “Unformatted Text”. This will paste the data as plain text, without any formatting or table structure.
4. Click OK in Paste Special dialog. Table is copied from Excel to Word as below.
ID NAME AGE PHONE ADDRESS
1 AAA 25 123 A1
2 BBB 25 321 A2
3 CCC 26 231 A3
4 DDD 27 213 A4
5 EEE 28 312 A5
Copy Table without Table Formatting via Paste Special -> Keep Text Only
Alternatively, you can also copy table without table formatting via Paste Special feature “Keep Text Only” method.
Here are the steps:
1. Select the table in the opened sheet, press Ctrl+C to copy it. In this example, the copied table is B2:F7.
2. In Word, go to the location where you want to paste the data, click Paste dropdown in the Home tab, choose “Keep Text Only” from the dropdown list.
Table is copied and pasted as below. The data is pasted into Word as plain text, without any formatting or table structure.
ID NAME AGE PHONE ADDRESS
1 AAA 25 123 A1
2 BBB 25 321 A2
3 CCC 26 231 A3
4 DDD 27 213 A4
5 EEE 28 312 A5