How to Paste Excel Table into Word in Landscape (3 Easy Ways)

Sometimes when we copy an Excel table to a Word document, it may require us to paste it as a landscape table. Both Excel and Word have amazing features to paste a table into landscape format. If you are also interested to get familiarizing yourself with how to paste an Excel table into Word landscape, then you choose the right article. Follow the content and download the workbook for practice.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Easy Approaches to Paste Excel Table into Word in Landscape

In this context, we are going to demonstrate 3 distinct methods of how to paste an Excel table into Word file. We consider a  dataset of 10 employees and their income for the first two months of any year. The name of the employee is in column B, and the income of months January and February are in columns C and D respectively. So, we can consider that our Excel table is in the range of cells B5:D14.


1. Paste Excel Table as a Picture into Word

In this process, we will paste the Excel table as a picture into our word document in the landscape format. The procedure of this method is given as follows:

📌 Steps:

  • First of all, launch Microsoft Word on your computer and click Blank document.

  • Now, select the entire range of cells B4:D14.
  • Press ‘Ctrl+C’ to copy the table into the clipboard.

  • After that, in the Insert tab, select Table > Excel Spreadsheet.

Paste Excel Table As a Picture into Word Landscape

  • An Excel spreadsheet will appear in Microsoft Word.
  • Select the drop-down arrow of the Paste option and choose the Picture option.

Paste Excel Table As a Picture into Word Landscape

  • Then, in the Picture Format tab, select the drop-down arrow of Rotate from the Arrange group.
  • Choose any of the options according to your desire. In our case, we choose to Rotate right 90°.

Paste Excel Table As a Picture into Word Landscape

  • Click the Arrow icon with your mouse to get the complete table in visual.

Paste Excel Table As a Picture into Word Landscape

  • Finally, click your mouse cursor at any empty space on the word page.
  • You will get that the table is placed on that page in the landscape format.

Paste Excel Table As a Picture into Word Landscape

In the end, we can say that our procedure worked successfully and we are able to paste an Excel table into Word.

Read More: How to Put a Large Excel Table into Word (7 Easy Methods)


2. Insert Through Text Box

In this following method, we will insert a text box to paste our Excel table in landscape format into the word file. We are going to use the previous dataset in this case also. The method is given below as follows:

📌 Steps:

  • At first, select the entire range of cells B4:D14.
  • After that, press ‘Ctrl+C’ on your keyboard to copy the dataset.

  • Now, launch Microsoft Word on your computer and click Blank document.

  • In the Insert tab, select Text Box > Simple Text Box from the Text group.

Insert Excel Table into Word Landscape Through Text Box

  • Then, right-click on your mouse, and in the Paste option, choose Keep Source Formatting(K) to paste the dataset into the text box.

  • Do all the necessary formatting to get better visualization.

Insert Excel Table into Word Landscape Through Text Box

  • Now, in the Shape Format tab, select Rotate > Rotate Right 90° from the Arrange group.

Insert Excel Table into Word Landscape Through Text Box

  • You can also use the Rotation Arrow above the text box to rotate the text box manually.

Insert Excel Table into Word Landscape Through Text Box

  • At last, you will get the table on that page in the landscape format.

Insert Excel Table into Word Landscape Through Text Box

So, we can say that our approach worked perfectly and we are able to paste an Excel table into Word.

Read More: How to Insert Excel Table into Word (8 Easy Ways)


Similar Readings


3. Changing Page Orientation

This method is the easiest one to paste Excel table into word as a landscape format. We are going to use the same table to show the approach to you. The steps of this process are given below:

📌 Steps:

  • Select the entire range of cells B4:D14.
  • Now, press ‘Ctrl+C’ on your keyboard to copy the table into the clipboard.

  • Then, launch Microsoft Word on your computer and click Blank document.

  • Right-click on your mouse and in the Paste option, choose Keep Source Formatting(K) to paste the table.

  • You can also press K on your keyboard to paste the table with the source formatting.

Changing Page Orientation to Paste Excel Table into Word Landscape

  • After that, in the Layout tab, click the Orientation option from the Page Setup group.
  • Change the Orientation from Portrait to Landscape.

Changing Page Orientation to Paste Excel Table into Word Landscape

  • You will find that the page layout is changed and the table is on that page in the Microsoft Word file.

Changing Page Orientation to Paste Excel Table into Word Landscape

Thus, we can say that our method worked successfully and we are able to paste an Excel table into a Word file.

Read More: How to Insert Excel Table into Word with Formulas (2 Easy Ways)


Conclusion

That’s the end of this article. I hope that this content will be helpful for you and you will be able to paste an Excel table into Word in the landscape format. If you have any further queries or recommendations, please share them with us in the comments section below.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo