All TalkersTech Sections

How To Put A Large Excel Table Into Word

Last Updated : Mar 4, 2022

How To Put A Large Excel Table Into Word

In this article we will show you how to put a large excel table into word, MS word and MS Excel are two tools used together by professionals all over the world. There are several times when one would need to merge multiple documents and files into a single document.

Thus, it would require one to shift and transfer the data in other documents into the final one.

It would also mean transfer of pictures, layouts, tables, etc. Tables created on Excel sheets can be as wide and huge as you would like them to be, depending on your needs.

Have you been trying to put large Excel sheet tables into a MS Word document and facing any challenges? If your answer to this question is a yes, then you have come to the right place.

Don’t you fret! In this article, we will see how you can add large Excel tables into Word documents in just a few quick and easy steps. Follow the procedure as explained in the steps below.

Step By Step Guide On How To Put A Large Excel Table Into Word :-

  1. On your laptop or PC, click on the Microsoft icon located at the left bottom corner of the screen. This will open the menu menu of your device and from under Microsoft Office, choose the ‘MS Excel’ document.

    How To Put A Large Excel Table Into Word

  2. Or if the document is saved on your device, simply go over to the location and click on the file icon to open and view it.
  3. Now, in Excel, choose the number of cells from the worksheet (for example, A3 to J40).
  4. Once you have selected the cells, you will need to copy the content. For that, press Ctrl+C.
  5. To proceed further, go to the MS Word document to which you wish to add the Excel table.
  6. Now, scroll to the location where you wish for the worksheet to be inserted and press Ctrl+V to paste.
  7. Now from the dropdown menu that shows up, select ‘Paste Special’ or simply click on the ‘Paste’ icon under the ‘Home tab’.

    How To Put A Large Excel Table Into Word

  8. Here you will be able to see a few options. From this menu, select ‘HTML Format’ and once you are done, then tap on the ‘OK’ icon.

    How To Put A Large Excel Table Into Word

  9. In the next step, bring the cursor in one of the worksheet header rows. This will open the ‘Table Tools’ menu. From this menu, click on ‘Layout’ icon and from here select the ‘Repeat Header Rows’ to repeat header rows on all the pages.

    How To Put A Large Excel Table Into Word

  10. In case the Excel table is wide, select the entire table and put it as landscape. If the table still does not fit within the 1-inch margins, then what you have to do is select the whole table.
  11. As soon as you do this, the ‘Table tools’ will be visible.
  12. Now go to ‘Layout’ tab and select the ‘Autofit’ icon.

    How To Put A Large Excel Table Into Word

  13. From the small list that opens, choose the ‘Autofit contents or Autofit window’.

    How To Put A Large Excel Table Into Word

Conclusion :-

I hope this article on how to put a large excel table into word helps you and the steps and methods above are easy to follow.

LATEST ARTICLES