How do I get out of bounds when an Excel datasheet is copied to Word?

Source: Internet
Author: User
Tags reset truncated

when a datasheet in Excel is copied to Word, the table style often crosses the line and the content is truncated.

Do you have a problem with this? There are two ways to fix this.

Automatic rearrangement of full content

The reason for this is that there are cases like this, because the AutoFit property of a table in a Word document defaults to "Adjust table by content," If the Excel worksheet you want to convert has more data width than the current Word document page, it's confusing that the table is truncated after you paste it directly.

To solve this problem, please do not rush to drag the table manually, which may cause chaos. Instead, you first need to select the table, right-click the mouse, and perform the auto adjust → adjust table by window command to make the table appear.

Reset the page to fit the original table size

Using the above method, although the contents of the table are all displayed, you may find that the column width of the table is compressed. This is because the word layout width is less than the width of the original Excel table. To do this, you can adjust the width of the layout in the layout settings, or you can invert the paper horizontally, and then in the table right-click menu in the "Auto adjust → fixed column width" command, the table's automatic adjustment properties are limited. If not, you can then reset the layout width by customizing until appropriate.

Note that this method is also subject to the width of the printed page support, if the paper is set too wide, although the screen can allow the full table, but the printer to print the full width of printing, it can only be scaled down to print.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.