How Word implements Excel table-column printing

Source: Internet
Author: User

how Word implements Excel table-column printing

In actual work, you will often encounter Excel tables that have fewer columns and many rows of data, as shown in the following illustration:

This data has two rows and 253 lines and now needs to be printed out.

Preview First:

Because the number of data columns is very small, the content is concentrated on the left side of the paper. Obviously, this kind of printing effect will make the boss crazy.

If you are typesetting directly in Excel, you need to cut and paste the operation more than once.

We can use Word to quickly implement column printing. First copy the data in Excel and paste it into Word.

Click Page Layout column, and then select two columns.

This can quickly achieve the effect of two columns, but there is a problem, in addition to the first page, the other pages of the beginning, have become not capped:

You're laughing at the leader. Summen have no hair??

If you have a problem, try to solve it: Click the title of the first page, "Layout" "Repeat header row".

Oh,-

Look at the effect of the print preview:

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.