Formatting Issues

Fix Excel Page Breaks Not Working When Pasting Data into Word

Kushani NimanthikaKushani Nimanthika Oct 9, 2026 876 views

Question details

The user needs a way to maintain original pagination when copying multi-page Excel data into Microsoft Word.

How to Fix Excel Page Breaks Not Working After Pasting Data Into Word
Product
Microsoft Word and Excel
Device & OS
not provided
Scenario
Pasting a multi-page selection from Excel into Word using the 'Keep Source Formatting' option.
Observed behavior
Word ignores the original Excel manual page breaks and converts the content into a continuous Word table, which may result in extra rows or completely different page breaks. Additionally, linked or embedded Excel objects remain confined to a single page.
Before you start

Before adjusting your document's layout, make sure your pasted Excel data has fully loaded in Word and enable the 'Show/Hide ¶' feature (Ctrl + *) on the Home tab to easily locate where Word has placed automatic table breaks.

Solution 1Recommended

Manually Insert Page Breaks in the Word Table

Since Word converts pasted Excel data into a native Word table and ignores Excel's pagination, the most reliable solution is to insert page breaks directly within Word.

When you use the 'Keep Source Formatting' paste option, Word attempts to match the visual style of the Excel cells but relies on its own table engine to handle pagination. Because Word's table engine does not interpret Excel's manual page breaks, you must re-apply them.

1
Locate the split point

Scroll through your pasted table in Word and click inside the specific row where you want the new page to begin.

2
Insert a page break

Navigate to the 'Layout' tab on the Word ribbon (ensure you select the general Layout tab, not the Table Tools Layout tab) and click on 'Breaks', then choose 'Page'. Alternatively, press Ctrl + Enter on your keyboard.

3
Adjust table properties (Optional)

If the table splits awkwardly across pages, right-click the table, select 'Table Properties', go to the 'Row' tab, and uncheck 'Allow row to break across pages' to keep your data rows intact.

Manually Insert Page Breaks in the Word Table
Limitation on Embedded Objects: If you paste your data as a linked or embedded Excel object (OLE) instead of a Word table, it will behave like a single image block and cannot wrap to the next page. It will always be confined to a single page in Word.
Free Microsoft Office alternative

Try WPS Office for Seamless Document and Spreadsheet Management

Since Microsoft Word natively ignores Excel page breaks when pasting data as tables, managing large datasets across platforms can be frustrating. WPS Office provides a highly compatible, lightweight, and free alternative with intuitive layout tools that make managing multi-page tables and cross-application pasting effortless.

Highly compatible with Microsoft Excel (.xlsx) and Word (.docx) formats, ensuring your data opens perfectly.Easily adjust multi-page table layouts and manage page breaks without formatting chaos.Lightweight software that runs smoothly on Windows, Mac, and Linux environments.Familiar user interface requiring zero learning curve for a seamless migration.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my embedded Excel object only show one page in Word?

When you paste Excel data as a linked or embedded object, Word treats the entire selection as a single unified graphic or block. Natively, these objects cannot span across multiple pages. To allow the data to span multiple pages, you must paste it as standard text or a Word table.

How can I repeat my Excel column headers on every page in Word?

After pasting your data as a table in Word, select the top header row. Right-click the selection and choose 'Table Properties'. Navigate to the 'Row' tab and check the box that says 'Repeat as header row at the top of each page'. Click OK.

Is there a way to keep the exact Excel print layout when moving to Word?

If you strictly need the exact visual print layout from Excel, including all predefined page breaks, it is recommended to save the Excel file as a PDF first. You can then insert or append the resulting PDF pages into your Word document.