How to make absolute reference to cells in excel

How to make an absolute reference to an excel cell: first open the excel table that needs to be operated, select the cell that needs to be operated; then enter the formula "= a certain cell" in the cell; finally You can make an absolute reference by pressing the "F4" key on your keyboard.

The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.

Select cell E2 and enter "=$C$3" in the formula editing bar, as shown in the picture. There is a trick here, because it is troublesome to enter the $ symbol. If we are sure that a certain cell To make absolute references to data in a cell, you can directly select the cell and press the F4 key to automatically convert it to the absolute reference format.

At this point, the formula has not been fully edited. We still need to reference cell D2 and continue to enter the formula. At this time, the formula in cell E2 should be "=$C$2" *$D$2".

Press the enter key to get the calculation result

Follow the same method and fill in the formula downwards, as shown in the figure The changes shown, all results are the same, no changes will occur.

If we put the mouse on cell E5, we will find that its formula is still "=$C$2*$D$2", and the formulas in other cells are also the same. . This is an absolute reference.

Related learning recommendations: excel tutorial

The above is the detailed content of How to make absolute reference to cells in excel. For more information, please follow other related articles on the PHP Chinese website!