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:
- 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.
- An Excel spreadsheet will appear in Microsoft Word.
- Select the drop-down arrow of the Paste option and choose the Picture option.
- 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°.
- Click the Arrow icon with your mouse to get the complete table in visual.
- 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.
In the end, we can say that our procedure worked successfully and we are able to paste an Excel table into Word.
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:
- 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.
- 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.
- Now, in the Shape Format tab, select Rotate > Rotate Right 90° from the Arrange group.
- You can also use the Rotation Arrow above the text box to rotate the text box manually.
- At last, you will get the table on that page in the landscape format.
So, we can say that our approach worked perfectly and we are able to paste an Excel table into Word.
- How to Auto Populate Word Document from Excel (with Quick Steps)
- How to Create Multiple Word Documents from Excel (3 Easy Methods)
- Excel VBA: Open Word Document and Replace Text (6 Examples)
- How to Insert an Excel Spreadsheet into Word (4 Easy Methods)
- How to Transfer Data from Excel to Word Automatically (5 Methods)
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:
- 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.
- After that, in the Layout tab, click the Orientation option from the Page Setup group.
- Change the Orientation from Portrait to Landscape.
- You will find that the page layout is changed and the table is on that page in the Microsoft Word file.
Thus, we can say that our method worked successfully and we are able to paste an Excel table into a Word file.
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!
- How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
- How to Copy Only Text from Excel to Word (3 Quick Methods)
- Excel VBA: Open Word Document and Paste (3 Suitable Examples)
- How to Open Word Document and Save As PDF or Docx with VBA Excel
- Copy Excel Table to Word with Gridlines (2 Simple Methods)
- How to Generate a Word Document from an Excel Macro