WPS Table relative Reference and absolute reference

Relative references and absolute references

A relative reference is the default reference for a WPS table, so the references we use in general are relative references. A relative reference is when you copy a cell's formula to another cell, the position of the cell referenced in the formula changes accordingly.

The most common use of relative references is to populate the formula. For example

In the table above, fill in the formula "=sum (A2:C2)" at D2, and then fill it down to line 6th, and the cells that are referenced in the formula for each row of column D will increase with the equals of the line where the formula is.

Suppose that all rows now need to be combined with a unified base. Insert a column before column A, set A2 to the value of the base, and the new table should appear to be

But in fact it was wrong, except for the 2nd line, all the parts did not add 50 points. Because A3 to A6 are all null values, do not participate in the calculation.

Here we want each row to refer to the value of the B, C, D three columns of the current row, while the value of the A2 cell is fixed, so--we should change the A2 to an absolute reference. An absolute reference is when a formula is copied to another cell, and the cell position of the absolute reference is not changed.

An absolute reference is represented by a $ symbol in front of the column or equal sign. For example, $a$2 represents an absolute reference to A2 cell; A$2 represents the row number of an absolute reference A2 cell, but its column is marked as a relative reference, $A 2 represents an absolute reference to the A2 cell's column label, but the line number is a relative reference.

Therefore, the correct reference to the basis of the above should be. Because the line number of the A2 is an absolute reference, the line number of the a$2 is invariant when the formula is copied down from E2, but the equal sign of B2 and D2 that are not absolute references change.

Computer Tutorials

Relative/absolute Reference conversion techniques

Relative references and absolute references are formally identified by $, but it seems a bit cumbersome to write this $ symbol every time on the operation. There is a simpler way to select the area identifier (name) in the formula that you want to change the reference to, and then press F4 to cycle through the absolute reference, the absolute reference row, the absolute Reference column, and the relative reference 4 different ways.

For example, refer to the A2 cell, select A2, or place the playback point on the A2.

Press F4, the reference becomes $A$2

Then press F4 and the reference becomes A$2

Then press F4 and the reference becomes $A2

Then press F4 and the reference becomes A4

...... (Continue to change by F4 cycle)

This technique also applies to zone names or multiple area identities, provided that they are selected.