Hafiz Islam
When you copy data from Excel to an MS word document in a straight way, it can be pasted with cells. If you wish to copy and paste from Excel to word without cells, you are in a right place. In this article, you will learn 2 quick ways to do this.
Download Practice Workbook
Download the following Excel file for your practice.
2 Quick Ways to Copy and Paste from Excel to Word Without Cells
Let’s introduce first our dataset. We have a dataset in a table format in an Excel worksheet. Our goal is to copy and paste it into MS word without a table.
1. Utilize the Paste Options
You can easily copy data from Excel and paste it to word without cells by using the 2 following paste categories.
1.1 Choose ‘Keep Text Only’
After copying the data from Excel and pasting it to word by choosing Keep Text Only option, the cells will be removed at once. Just follow the steps below to do this.
Steps:
- First, copy the data you need to paste it into word.
- Now, Right-click on the word document where you want to put your data without cells. Then, under the Paste Option, choose Keep Text Only.
Finally, here is the result.
1.2 Choose ‘Unformulated Text’ under Paste Special Section in Word
This is another technique you can use to copy data from Excel to word without cells. Just follow the steps below.
Steps:
- First, copy the data you need to paste it into word.
- Now place the cursor in your Word file where you need to put your Excel data. Go to Home tab > Paste > Paste Special. A paste special window will pop up.
- Choose Unformulated Text > click OK.
The result will be as follows.
Read More: How to Copy Only Text from Excel to Word (3 Quick Methods)
Similar Readings
- Convert Excel to Word Labels (With Easy Steps)
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- Excel VBA: Open Word Document and Paste (3 Suitable Examples)
- How to Generate a Word Document from an Excel Macro
2. Copy and Paste from Excel to Word Without Cells Using the Convert to Text Function
If you need to put the data formatting without cells, you can use the Convert to Text feature in your Word document. Just follow the steps below.
Steps:
- First, copy the data you need to paste it into word.
- Then, just paste it normally to your word file where you want to keep your data. Now Go to Data table > Layout > Convert to Text. A Convert to Text dialog box will appear.
- Under the Separate text with, choose one separator (In this example, we choose Tab ) you like to put, and finally, click OK.
Finally, here is the result.
Read More: How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
Conclusion
In this tutorial, I have discussed 2 quick ways to copy and paste from Excel to word without cells. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
