How to Paste Excel Table into Word Fit to Page

Get FREE Advanced Excel Exercises with Solutions!

If you are looking for how to paste an Excel table into Word to fit onto a page, then you are in the right place. Using Excel and Word simultaneously is a common thing in our working sector. Sometimes, we need to use Excel tables but need to apply those in Microsoft Word. In this article, we’ll try to discuss how to paste an Excel table into a Word fit to page.


How to Paste Excel Table into Word Fit to Page: Step-by-Step Procedures

Pasting an Excel table into Word is a very easy task. We just need to follow some simple steps.

1. Creating Excel Table

The simplest method to paste an Excel table into a Word file is to paste it as plain text. To do this, we have to create a table first in Excel.
So, firstly, open a new Excel worksheet.
Secondly, create a table like this.

paste excel table into word fit to page

Here, we have column headers as Machine Model, Launching Year, Color, Agency, and Price.
We’ll now paste it to a Word file.

Read More: How to Put a Large Excel Table into Word


2. Copying and Pasting the Table to a Word File

To work in the Word file, firstly, select the table containing cells of B4:F13.
Secondly, right-click the selected cells > choose Copy.
We can also copy by clicking CTRL + C.

Copying and Pasting the Table to Word File

Thirdly, open a new Microsoft Word file.

paste excel table into word fit to page

Fourthly, go to Home of the Word file > select Paste.
Or, we can use the keyboard shortcut CTRL +  V to paste.

Eventually, we’ll see that the table is pasted to the Word file like this.

paste excel table into word fit to page

Read More: How to Copy Table from Excel to Word


3. Fitting Table to Page

After pasting the Excel table into the Word file, our main task is to fit the table into the Word page. Because without fitting the table, it will be tough to use.
So, firstly, select the table.
Secondly, go to Layout (Table Layout) > Select AutoFit > choose AutoFit Contents or AutoFit Window.

Fitting Table to PageConsequently, our table will fit to the page like this.

paste excel table into word fit to pageNote: A major drawback of this method is that it will provide a static solution where you can change any data in your Excel but that doesn’t affect the table in Word format.

Read More: How to Paste Excel Table into Word in Landscape


How to Put an Excel Table into a Pre-Made Table in Word

We can paste an Excel table into a pre-made table in Word easily. The main difference between pasting into a pre-made table and pasting as normal text is that in the pre-made table, if we change any data in an Excel table, it will automatically change the table into Word.

Steps:

To show this procedure, firstly, we need to open a Word file.
Secondly, go to Insert > select Table > choose Insert Table.

How to Put an Excel Table into a Pre-Made Table in Word

Eventually, an Insert Table window will appear.
Thirdly, fix the Number of columns and Number of rows in the Table Size box. In this case, it is 5 and 10 respectively.
Fourthly, click OK.

A table will be made in a Word file like this.

Fifthly, select the whole cells of the table in Excel > right-click > choose Copy.

Sixthly, in the Word file, go to Home > select Paste > choose Paste Special

paste excel table into word fit to page

A Paste Special window will appear.
Seventhly, choose Unformatted Unicode Text > click OK.

Eventually, the table as output will be like this.


How to Insert Excel Table into Word with Formulas

When we have a table in Excel with formulas, we can also paste it into the Word file. The procedure is pretty much similar to the previous one. We just need to change the way a little. Although there are a couple of methods to do this, we will discuss the easier one.
Suppose in the following dataset, we have column headers of Machine Model, Quantity, Unit Price and Total Price.
In the Total Price column, the outputs are the multiplication of Quantity and Unit Price. For example, in the E5 cell, the formula is.

=C5*D5

Here, C5 and D5 refer to the first Quantity and Unit Price.

How to Insert Excel Table into Word with Formulas

Similarly, all the values in the E Column hold a formula.

paste excel table into word fit to page

We have created the table like the following figure containing the dataset.

Now, we need to paste this table with formulas into the Word file.

Steps:

So, firstly, select the cells > right-click > choose Copy.

Secondly, in the Word file, go to Home > click Paste > choose Paste Special.

In the Paste Special window, choose Microsoft Excel Worksheet Object > select Paste > click OK.

paste excel table into word fit to page

Eventually, the table will be pasted into the Word file.

Read More: How to Insert Excel Table into Word with Formulas


Things to Remember

If we don’t create a table in the Excel file by selecting cells and then going to Insert > Table, while pasting in the Word file, in the Paste Special window we won’t have enough options to choose from. So, we have to create the table in the Excel dataset first.


Download Practice Workbook


Conclusion

That’s all about today’s session. And these are the ways to paste Excel tables into Word fit to page. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section.


Related Articles

<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo