WPS table columns print a spreadsheet you can do it.

Source: Internet
Author: User

When it comes to column printing et or excle, you may be affected by the Luo moderator tutorial, find it difficult, in fact, the daily form of the column printing is a piece of cake, who can easily do.

To the ROM version of the newsletter as an example, the implementation of the "edit" → "move or copy the worksheet", the newsletter copy into a new workbook (you can open their usual edited newsletter).

1, select column B, copy, perform "edit" → "paste" → "value (also selectable value and number format)", the original use of the virtual mobile phone number into numbers. Your own newsletter can skip this step.

2, selected A1:c1, the use of automatic filling, the column label copied to D1 to I1.

3, observe the original data, according to their own needs to the original middle and lower data copied and pasted to the appropriate location. You can also use a cut, move, or reference method to copy data.

4, select the area you want to print.

Final effect:

We are more confused about the place is often with the function of the data columns, now to the student transcripts as an example to introduce.

Figure below the student transcript a total of 54 lines, if divided into two columns, considering to the right also to add a label, to the 29th row of data to the right.

1, add column label, select A1 to G1, use automatic fill to N1 lattice.

2, click H2, Input =a29, the use of automatic filling, copy the lower part of the original form of data to the right.

3, add a border, remove the reference to the empty cell to bring the 0 value.

4, print the required parts.

Bottom of the original table:

Final effect:

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.