How to divide an Excel worksheet into two pages when inserting it directly into Word

Reported answer
How to divide an Excel worksheet into two pages when inserting it directly into Word
Ask online customer service
Scan the code to ask online customer service

It was only after inserting excel that I started filling in the form. The result was too many, but only one page could be displayed in Word···

  • Number of answers

    five

  • Number of browses

    nine hundred and ninety-three

5 answers Default sorting
  • Default sorting
  • Sort by time

Didn't find a satisfactory answer? Go ask Doubao AI intelligent assistant
Adopted
In Microsoft Word, you can split a table into two pages by:
1. Select the table to split, find it at the top of the toolbar and click the "Layout" tab. Under this tab, click the "Split Table" button.
2. If you want to import the content into Excel and split it in Word, you can use the following steps:
a) Save the Excel file in plain text (. txt) format or plain text picture (. txt) format.
b) Insert these data sources into a Word document.
c) Select the text or table content and select the Find and Replace function to replace all bullets or tabs as paragraph spacing.
d) Adjust paragraph spacing as needed to achieve the desired page layout.
Please note that when performing the above operations, other settings can be adjusted according to specific needs to achieve the best results.
cancel comment
Select a cell, and then split the cell in the Tools menu. It will show how many cells are split into. Fill in the numbers yourself
cancel comment
It can be directly modified in WORD
1. Select the table, click "Split Table" in "Layout" on the upper right corner of the toolbar;
2. If the content can be imported into EXCEL, it can be copied separately from EXCEL to WORD;
cancel comment
Or, after editing the content directly in Excel, select the part to be separated, use the shortcut keys Ctrl+Enter to create a new page (or hold down the Shift key to drag the scroll bar to the bottom), and then copy and paste it into the Word document. Remember to add page breaks manually after each section
cancel comment
After inserting an Excel worksheet in Word, you can select the View menu and find that the display scale is adjusted to 50%, so that you can view two pages at the same time. Next, move the cursor to the place where you want to disconnect, right-click to select the split cell, and then save it as two separate tables
cancel comment
ZOL Q&A > How to divide an Excel worksheet into two pages when inserting it directly into Word

Top mobile phone rankings

See more rankings>

report

Thank you for contributing to the harmony of the community. Please select the type of report

Reported successfully

It will be handled after verification
Thank you for your contribution to community harmony

Scan the code to participate in the trial of new products at 0 yuan
You can get the sheets and grand gifts on the top floor

 Scan and pay attention to us
Tips

Are you sure you want to cancel this registration and exit this activity?