How to print columns in a WPS table

Source: Internet
Author: User

As we all know, when the form is finished, it needs to be printed as well as the document to facilitate circulation. But what if you want to print only a subset of the data in the table? The following small series for you to introduce how the WPS table for the column printing, a look at it.

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).

Sub-column printing

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.

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.

Student Grades

Student transcript if divided into two columns, consider to the right also to add a label, to the 29th row of data to move 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.

The above is the WPS table for column printing method. First to copy the sticky value, and then select the area you want to print, of course, if you are engaged in educational work of friends, on the function of the data column, above also mentioned the Operation method, I hope that the above content for you to help.

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: and provide relevant evidence. A staff member will contact you within 5 working days.