Relative reference and absolute reference of Excel

A1 It's a relative reference

$A1 Absolute reference column Is a mixed reference The column does not change

A$1 Absolute reference line Is a mixed reference The line doesn't change

$A$1 Absolute reference to rows and columns It's an absolute reference The ranks remain the same

$ Who is absolutely quoted in front of who

F4 Is a shortcut key to convert four kinds of references to each other ( Press... While entering the formula in the edit bar F4 Function keys can be used for switching )

A1( Relative reference )

When you drag a reference from the drop-down menu , Will become a reference A2,A3,A4..., When you drag right, the reference becomes B1,C1,D1....

A$1( Mixed reference , Absolute application line )

Drop down... When you want to copy A1 When the cell is ,A1 Just add $ Symbol , become A$1, In this way, when you pull down, you can ensure that A The relative reference of the first row of the column ( That is, keep the line number unchanged during reference )

$A1( Mixed reference , Absolute reference column )

When you right-click the copy, you want to make sure that only A1 When the cell is ,A1 Just add $ Symbol , become $A1, In this way, when you pull right, you can ensure the right A The relative reference of the first row of the column ( That is, keep the column mark unchanged during reference )

$A$1( Absolutely quote )

When you copy in the drop-down and right-click, you want to ensure that only A1 When the cell is ,A1 Just add $ Symbol , become $A$1, In this way, when pulling down and right, it can ensure the right A The absolute reference of the first row of the column ( That is, keep the row number and column mark unchanged during reference )

Reference resources ： stay Excel in $A$1 and $A1 Is the difference between the ？？？_ Baidu knows (baidu.com)