Formatting Issues

How to Fit a Large Excel Table into Word Using Landscape Pages

Muhammad Talha Oct 9, 2026 868 views

Question details

The user needs to paste and format a wide Excel table into a Word document without data being cut off or becoming difficult to read.

How to Fit a Large Excel Table Into Word Using Landscape Pages

Product: Microsoft Word / WPS Writer
Device & OS: not provided
Scenario: Pasting a wide Excel spreadsheet into a standard portrait-oriented Word document.
Observed behavior: The wide table exceeds the standard page margins, causing data loss on the right side and rendering the spreadsheet unreadable.

Before you start

Ensure your Excel data is finalized and cleaned up before pasting it into Word, as this will minimize the need for manual column adjustments after changing the page layout.

Solution 1Recommended

Use Section Breaks to Change Orientation to Landscape

Isolate the table onto its own pages using section breaks so you can apply landscape orientation strictly to the table while keeping the rest of the document in portrait.

Applying landscape orientation to a single page requires breaking the document's formatting continuity. Section breaks act as invisible dividers, allowing you to have different page layouts within the same document.

Copy and Paste the Table

Copy your large table from Excel and paste it into the desired location in your Word document.

Insert Section Breaks

Place your cursor immediately before the table, go to the Layout tab, click Breaks, and select Next Page under Section Breaks. Repeat this step immediately after the table.

Change Orientation to Landscape

Click anywhere inside the newly created section containing the table. Navigate to the Layout tab, click Orientation, and select Landscape.

AutoFit to Window

Select the entire table by clicking the crosshair icon in its top-left corner. Go to the Table Layout tab, click AutoFit, and choose AutoFit Window to ensure the table spans perfectly across the new landscape margins.

Use Section Breaks to Change Orientation to Landscape

Pro Tip: You can manually adjust individual column widths by dragging the column borders if certain text still looks cramped after applying the AutoFit Window setting.

Solution 2

Apply Landscape Orientation via Page Setup Dialog

Quickly apply landscape orientation directly to the selected table without manually inserting section breaks first.

Handle Tables Easily

Seamlessly Integrate Wide Excel Tables in WPS Office

WPS Office makes it incredibly simple to insert, format, and adjust wide Excel spreadsheets inside your text documents. With advanced layout tools, you can mix portrait and landscape pages effortlessly without breaking your document's flow.

1. Copy and Paste: Copy the table from WPS Spreadsheet and paste it into WPS Writer.
2. Highlight the Table: Click the selector icon in the top-left corner of the table to highlight all rows and columns.
3. Change Layout to Landscape: Go to the Page Layout tab, click Orientation, and select Landscape. If prompted, apply this setting strictly to the 'Selected text' to automatically create section breaks.
4. AutoFit Table: Under the Table Tools tab, click AutoFit and select AutoFit to Window to properly align the table within the landscape page margins.

Fully compatible with Microsoft Word and Excel formats (.docx, .xlsx)One-click AutoFit to Window ensures tables never exceed page marginsIntuitive section break management for mixed page orientationsLightweight, fast, and completely free to use

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel table cut off on the right side when pasted into Word?

This happens because the wide Excel table exceeds the standard portrait margins in a Word document. To fix this, you must either change the page orientation to landscape for that specific section or use the AutoFit to Window feature to shrink the table.

Does AutoFit Window work for extremely large tables?

AutoFit to Window is highly effective for most tables. However, if your table contains dozens of columns, the text might become severely squished and unreadable. In these extreme cases, combining AutoFit with landscape orientation or reducing the font size is necessary.

How do I change the orientation back to portrait after the table?

If you used a 'Next Page' section break after your table, simply click into the page following the table, go to the Layout tab, and set the Orientation back to Portrait. The pages preceding the table will remain in portrait, the table in landscape, and the pages following back in portrait.

Can I link the Excel table to Word so it updates automatically?

Yes. When pasting the table into Word, choose 'Link & Keep Source Formatting' or 'Link & Use Destination Styles' from the Paste Options menu. Any subsequent changes made in the original Excel file will automatically reflect in the Word document.

Document & File Issues