Fix Excel Page Breaks Not Working When Pasting Data into Word
Question details
The user needs a way to maintain original pagination when copying multi-page Excel data into Microsoft 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 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.
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.
Scroll through your pasted table in Word and click inside the specific row where you want the new page to begin.
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.
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.

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.

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.




