How to transfer Excel data to Word?

Today we want to talk about one of the features of this software. Maybe you need it too. In fact, today, you will see how to transfer the information of an Excel worksheet to other software such as Word. We introduce How to transfer Excel data to Word.

Step by step to transform Excel data to Word

First select the relevant information.

How to transfer Excel data to Word

How to transfer Excel data to Word

Step2: Right-click and hit Copy or use Ctrl + C.

Step3: Open a word document file.

Step4: On the Home tab, click Paste Special to open the Paste Special window.

How to transfer Excel data to Word

Step5: Select HTML Format and click OK.

How to transfer Excel data to Word

You can use Ctrl + V instead of step 4-5.

In this case, we did a simple and normal copy and brought the information to word. The copied table does not contain margins. You must select it, click on the left top of it. There is an icon. Add it to the border table, or style the whole table.

How to transfer Excel data to Word

Paste as a link from Excel

You can transfer the information in a way that is also changed in Word by changing it in Excel. In fact the table inside Word is not a simple text and is a link to the information inside the Excel file.

Like the previous one, open the Past Special window. Be sure to enable the Paste link option and then select HTML Format.

How to transfer Excel data to Word

Now, if you change the information in Excel, it changes here.

How to transfer Excel data to Word

How to transfer Excel data to Word?
4.4 (87.37%) 19 vote[s]

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *