相对引用使用的场合比较多，但有时候也会用到绝对引用，这时候复制或者填充单元格时，单元格中的行与列的位置不会发生改变。
There may be times when you do not want a cell reference to change when copying or filling cells. You can use an absolute referenceto keep a row and/or column constant in the formula.
绝对引用设计时，要在公式中单元格的列号或者行号前面添加$符号，可以添加一个，也可以添加两个。
An absolute reference is designated in the formula by the addition of a dollar sign ($) . It can precede the column reference, the row reference, or both.
应用推荐