Absolute reference to f4 cannot be used

Absolute reference f4 cannot be used

Absolute reference f4 cannot be used in excel because some notebooks require key combinations , just use fn f4.

If you want to add an absolute reference to a function in excel, you need to select the object to which you want to add an absolute reference or place the cursor before the row number and column number of the object, and then click the F4 key to make an absolute reference

The following introduces how to use f4 absolute reference:

1. It is more practical among those who use formulas. It is used very, very much in scientific research and statistics.

2. Select A2:A6 in the formula, press F4, and press Enter (return is required), and all rows and columns will be locked (that is, absolute references).

3. Continue to select the contents of the brackets, press F4 and press Enter. It becomes an absolute reference to the row and a relative reference to the column

4. Continue to select the contents of the brackets, press F4 and press Enter. It becomes a relative reference to the row and an absolute reference to the column.

Recommended Tutorial: excel tutorial

The above is the detailed content of Absolute reference to f4 cannot be used. For more information, please follow other related articles on the PHP Chinese website!