How to Copy and Paste from Excel to Word Without Cells (2 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

2 Quick Ways to Copy and Paste from Excel to Word Without Cells


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.

Choose 'Keep Text Only'

  • 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.

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.

Choose 'Unformulated Text' under Paste Special Section in 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.

By Choosing Unformulated Text under Paste Special Section

  • Choose Unformulated Text > click OK.

By Choosing Unformulated Text under Paste Special Section

The result will be as follows.

Read More: How to Copy Only Text from Excel to Word (3 Quick Methods)


Similar Readings


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.

Copy and Paste from Excel to Word Without Cells Using the Convert to Text Function

  • 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.

Copy and Paste from Excel to Word Without Cells Using the Convert to Text Function

  • Under the Separate text with, choose one separator (In this example, we choose Tab ) you like to put, and finally, click OK.

Copy and Paste from Excel to Word without Cells using Convert to Text Function

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.


Related Articles

Hafiz Islam
Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo