How to enter absolute reference

Input method of absolute reference: First open the Excel file that needs to be operated, and apply the formula to the selected range; then drag to select the range that needs to be modified; finally press the "F4" key to select the part It can be changed to absolute reference format.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Input method of absolute reference:

1. First open the Excel file that needs to be operated, and apply the formula to the selected range, as shown in the figure.

#2. Then drag the left mouse button to select the range of references that need to be modified, as shown in the figure.

#3. Then press the "F4" key, and the selected part can be changed to absolute reference format.

Related learning recommendations: excel tutorial

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