WPS Table Reference: The representation of cells and ranges

Column and line numbers

WPS table, you need to refer to that cell if you want to use the value of another cell in the formula. To refer to a cell, you need to know the name of each cell.

The top of the WPS table is a line of letters ordinal number, a, B, C ..., they are column labels; the leftmost is a column of numeric numbers, 1, 2, 3 ..., they are line numbers.

Well, if you don't find the label and line number, it must not be shown. On the View toolbar, or on the view page of the Options window, select Show row number column labels to display the column and equal signs.

The name of a single cell

When a cell is selected, its corresponding column and line labels are highlighted in yellow, and the highlighted column and line labels are grouped together, which is the name of the cell, the B3 cell of the following figure

Computer Tutorials

Name of contiguous region

Drag or shfit+ the arrow keys to select a contiguous number of cells in a rectangular area, which is the connection area. With the name of the cell in the upper-left and lower-right corner of the range, a colon (:), which is the name of the area, for example, the following image is A2:C3

The representation of an entire column or whole row

Use the mouse to click or drag on the column label to select the entire single column or multiple columns; In the same way, you can select an entire single line or multiple rows by clicking or dragging with the mouse on the row number.

The name of a single whole column is the two current column label connected with a colon, as A:A represents the 1th column. The names of multiple columns are the first and last column columns that are concatenated with colons, such as B:d for 2nd, 3, and 4 columns. The entire row is represented in a similar way, such as 2:2,10:28.

Representation of multiple regions

The WPS table allows you to select more than one area, which can be contiguous or nonadjacent. The representation of multiple zones is to concatenate the names of these areas with commas (,), as shown in the following figure by 4 regions: (B2,B4:B5,C2:E2,D3:E5)

Select multiple zones by holding down the CTRL key while using the mouse to select areas to implement.

Because a comma is used to separate multiple parameters in a function, it is common to enclose a multiple-region identifier in parentheses as a whole when using multiple regions in a function.

Representation of the entire table

Use the mouse to click the upper left corner, which is the intersection of the column and line numbers, you can select the entire table. The representation of the entire table is a1:iv65536, that is, a contiguous region bounded by the limit size of the table (1~256 column and 1~65536 column).

Cell reference Example

The following shows several scenarios for a cell/range reference. C2 cells refer to a single cell, E3 cells reference a rectangular region, and F3 references the entire column.