Sometimes, you may want to copy a table from Excel to Word without the borders. This can be useful if you want to keep the table’s data but not its formatting. In this lesson, you learn how to copy a table without borders from Excel to Word.
Table without borders
Your task is to copy a table without borders from Excel to Word.
How to copy a table to Word?
To do this, follow these steps:
Select the table in Excel. Copy [CTRL + C keyboard shortcut] the table.
Open the Word document where you want to paste the table. Position the cursor where you want to insert the table.
Right-click and select “Paste Options”.
In the “Paste Options” dialog box, select “Keep Text Only”.
The table will be pasted into the Word document without its borders.
There is new problem. Headers and some values are not properly copied. However you can quickly correct it by format document in Word application. In my example I did it by putting cursor before text and pressing Tab button.
You can also use the “Paste Special” option to select a different paste format, such as “Paste as Picture” or “Paste as HTML”.
Note: The appearance of the table in Word may differ slightly from the original table in Excel, depending on the paste format you choose.
Here are some additional tips for copying tables from Excel to Word:
If you want to keep the table’s formatting, you can use the “Paste Special” option instead of the “Keep Text Only” option.
If you want to copy a table with a lot of data, you may want to use the “Paste as Picture” option. This will create a picture of the table in Word, which can be easier to work with if the table is very large.
If you want to copy a table and then make changes to it in Word, you can use the “Paste as HTML” option. This will create an HTML version of the table in Word, which you can then edit using Word’s HTML editing tools.