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!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
