Two ingenious methods for the narrow table columns of the Kingsoft WPS document

We often encounter such a table in peacetime: Only a narrow column, but a lot of rows, as shown in Figure 1.

In this way, you can only occupy a small portion of each piece of paper while printing, but use a lot of sheets. At this point, we want to be able to divide the table into several columns to print, as shown in Figure 2, in order to save paper.

As in the example above, the original form was made in the Jinshan form of WPS 2005, and we needed to print it in three columns.

Method One: Seek cooperation, print with Jinshan text

In order to be more convenient and quick, we can ask WPS 2005 Jinshan text to help.

First select all the data in the Jinshan table, press the "CTRL + C" key to copy. Then open Jinshan text, a new file, click the menu command "format → columns", in the Open "Column" dialog box, set three columns, as shown in Figure 3.

Press the "Ctrl + V" shortcut key, you can see that the pasted form has been automatically divided into three columns displayed. The drawback is that the next two columns do not have a header row. However, it is not difficult to add a header line. Select the header row in the first column, right-click, and select Table Properties from the pop-up shortcut menu to open the Table Properties dialog box. Click on the "Rows" tab and select the "repeat as header row at the top of each page" option, as shown in Figure 4. Once you are sure, the table for each column will automatically add the header line.

If you also want to make the rows of columns as evenly distributed as possible, you can select all rows of data, and then open the dialog box shown in Figure 4. Select the Specify height check box above, and in the following input box, enter a row height value and adjust the line height below to fixed value. Line Gaoyao According to the number of data flexible grasp, more than a few adjustments can be.

After the adjustment is completed, it is possible to print directly in Jinshan text.

Method two: Self-reliance, print in Jinshan form

If you do not want to use Jinshan text, and you have the function of Jinshan table proficiency, then, we can also directly in the Jinshan form completed alone.

The example is shown in the three columns of the table shown in Figure 1 above. The idea is to first determine the number of rows in the data, and then use the function to display all the first one-third of the data in another region, then move one column, display the middle One-third data, and so on.

In the E2 cell, enter the formula =if (ROW () >int (COUNTA ($A: $A)/3) +2, ", OFFSET ($A $1,row () -1,0))" (excluding the outer double quotes). Select the cell again after you press ENTER, and drag its fill handle to the right to fill the formula to the G2 cell. Click F2, G2 cells, and then modify the last data "0" in the formula to "1", "2" respectively. When you enter, you can see that the first row of data has been referenced.

Select cell E2:g2, and drag the fill handle down to copy the formula. When the number of rows exceeds one-third of the number of rows, it doesn't matter if you drag a few more rows, it doesn't affect the data display. After you release the mouse, you can see the first One-third data references.