Site icon excelwrap

How to copy table from Excel to word

How to copy table from Excel to word

While working, we often need to add tables in Microsoft word. Though you may find table commands in MS word, you may feel comfortable preparing your table in MS Excel and then copying the table from Excel to word. Today, in this article, I will guide you on how to copy a table from Excel to word. I will show you the three easiest ways to perform the task.

Three most effortless ways to copy tables from Excel to Word

Use keyboard Shortcut

This is the most convenient and easy way to copy a table from MS excel and paste it into a Word file. Okay, let us describe the procedure. Please follow the steps below to learn.

The benefit of this process is you can format the table as a Microsoft Word table. You can edit, modify and change color whatever you want to do.

Paste Special features in MS Word

Microsoft Word has a fantastic feature called Paste Special to paste anything into it. When you go for the paste special command and paste an excel table into a word file you will find two options to choose from.

Both of the options are great with their own features. I will describe here what facilities you can get from them.

Paste the table as a linked MS Excel object

Your selected table from the excel file is in the word file now. The basic facilities you will get paste link is if you change any value of any cell it automatically reflects on the word file as both are linked together.

If your word file does not update automatically please follow the steps below to update.

Read More: How to sum up using Excel; SUM Function explained.

Paste the table as a static object

Maybe you do not know this is actually an embedded excel sheet in a word file. If you double-click the table in Microsoft Excel will open in front of your Microsoft Word file to edit or modify.

Paste the table as a linked Image

Your selected table from the excel file is in the word file as an image now. The basic facilities you will get as a paste link is if you change double click on the image the Excel file will open and you can edit or modify the image there. After saving the excel your image in the word file will be updated automatically.

Read More: How to print large excel sheet on one page

Paste the table as a static object

Basically, it is fixed and farm, this image will not change as it is a static object. We can have an experiment to check by data changing.

These are the methods of copying a table from an MS Excel file to paste it into an MS Word file. I have tried to guide you through all possible methods on How to copy tables from Excel to word and I hope this article will be helpful to you. If you feel that it is really helpful content for you please post a comment for us. Thanks a lot for reading our content.

Exit mobile version