How to Display an Embedded Excel Spreadsheet Across Two Word Pages
Question details
The user needs a large embedded Excel spreadsheet to display continuously across two or more pages in a Word document without the data being cut off.
- Product
- Word
- Device & OS
- not provided
- Scenario
- Inserting a large Excel dataset into a multi-page Word report where the data exceeds the vertical height of a single page.
- Observed behavior
- The embedded Excel spreadsheet behaves like a single image or object, failing to break across pages automatically and getting cut off at the bottom margin.
Because embedded Excel objects in Word function like single images, they cannot physically split across a page break. You will need to decide whether to retain live Excel editing features or convert the data into a flowing Word table.
Convert the Excel Data to a Native Word Table
The most effective method to allow data to flow naturally across multiple pages is to paste the Excel spreadsheet as a native Word table.
By converting the embedded object into a native table, Word regains control over the text wrapping and page breaks, allowing rows to transition smoothly from one page to the next.
Double-click your embedded Excel object to open the editing mode, select all the data you want to display, and press Ctrl+C to copy it.
Click outside the object in your Word document, right-click, and choose 'Keep Source Formatting' or 'Use Destination Styles' under the Paste Options to insert the data as a Word table. You can safely delete the original embedded object afterward.
Select the newly inserted table, right-click, and click on 'Table Properties'. Navigate to the 'Row' tab and check the box that says 'Allow row to break across pages', then click OK.
Adjust the Embedded Object's Scaling and Visible Area
If you strictly need to maintain the data as a live Excel object for complex formulas, you can adjust its scaling to fit on a single page.
Easily Manage Large Tables with WPS Office
WPS Office offers flawless integration between its Spreadsheet and Writer applications, allowing you to easily copy large datasets and paste them as format-compatible native tables that automatically flow across multiple pages.
- 1. Copy data from WPS Spreadsheet: Open your large dataset in WPS Spreadsheet, highlight all required cells, and copy the selection.
- 2. Paste into WPS Writer: Switch to your document in WPS Writer, right-click where you want the data to appear, and select Paste to insert it as a fully editable table.
- 3. Enable page breaks: Right-click the inserted table, select Table Properties, go to the Row tab, and check 'Allow row to break across pages' for continuous display.
Frequently Asked Questions
Why does my embedded Excel object get cut off at the bottom of the Word page?
In Word, embedded Excel spreadsheets are treated as OLE objects, which behave similarly to images. Because they act as a single continuous block, they cannot physically split into two pieces across a page break.
Can I keep my Excel formulas active while allowing the table to span two pages?
Not directly as a single object. To keep live formulas, you would need to split your data into two separate embedded Excel objects, placing one on the first page and the other on the second page.
How do I repeat my table headings on the second page in Word?
Once you have converted your embedded object to a native Word table, select the top header row, right-click, and choose 'Table Properties'. Go to the Row tab and check the box for 'Repeat as header row at the top of each page'.
