In this article, we will demonstrate 3 distinct methods to paste an Excel table into a Word file in Landscape orientation. We’ll use the dataset below of 10 employees and their income for the first two months of a year. Our Excel table is in the range B5:D14. Let’s copy and paste this table into a Word document.
Method 1 – Paste Excel Table as a Picture
Steps:
- Launch Microsoft Word and click Blank document.
- Back in Excel, select the entire range of cells B4:D14.
- Press ‘Ctrl+C’ to copy the table onto the clipboard.
- Go back to the Word document.
- From 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.
- In the Picture Format tab, select the drop-down arrow of Rotate from the Arrange group.
- Choose any of the options at your discretion, for example Rotate right 90°.
- Click the Arrow icon with your mouse to get the complete table in view.
- Click your mouse cursor on any empty space on the Word page.
The table is placed on that page in the landscape format.
Read More: How to Paste Excel Table into Word Fit to Page
Method 2 – Insert Through Text Box
We can alternatively insert a text box into which to paste our Excel table into a Word file in landscape format.
Steps:
- Select the entire range of cells B4:D14.
- Press ‘Ctrl+C’ to copy the dataset.
- Launch Microsoft Word and click Blank document.
- From the Insert tab, select Text Box > Simple Text Box from the Text group.
- Right-click on your mouse, and in the Paste option, choose Keep Source Formatting(K) to paste the dataset into the text box.
- Do some formatting to get better visualization.
- In the Shape Format tab, select Rotate > Rotate Right 90° from the Arrange group.
- Alternatively, use the Rotation Arrow above the text box to rotate the text box manually.
The table is inserted in landscape format.
Read More: How to Put a Large Excel Table into Word
Method 3 – Changing Page Orientation
This is the easiest way to paste an Excel table into Word in landscape format.
Steps:
- Select the entire range of cells B4:D14.
- Press ‘Ctrl+C’ to copy the table.
- Launch Microsoft Word and click Blank document.
- Right-click on your mouse and in the Paste option, choose Keep Source Formatting (K) to paste the table.
- Or, press K on your keyboard to paste the table with the source formatting.
- In the Layout tab, click the Orientation option from the Page Setup group.
- Change the Orientation from Portrait to Landscape.
The page layout changes and the table is included on that page.
Read More: How to Copy Excel Table to Word with Gridlines
Download Practice Workbook
Related Articles
- How to Copy Table from Excel to Word
- How to Insert Excel Table into Word
- How to Add Drop-Down List in Word from Excel
- How to Create Multiple Word Documents from Excel
- How to Insert Excel Table into Word with Formulas
- How to Auto Populate Word Document from Excel
<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!