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!