详细介绍Excel相对引用，绝对引用和混合引用的区别与规律。具体说明，加上了绝对引用符“$”的列标和行号为绝对地址，在公式向旁边复制时不会发生变化，没有加上绝对地址符号的列标和行号为相对地址，在公式向旁边复制时会跟着发生变化。混合引用时部分地址发生变化。



　　相对引用、绝对引用和混合引用是指在公式中使用单元格或单元格区域的地址时，当将公式向旁边复制时，地址是如何变化的。 具体情况举例说明：

-Details Excel relative reference to an absolute reference to the difference between law and mixed references. Specify, plus the absolute reference symbol " $"　column headings and row number absolute address does not change in the formula is copied to the next, no column headers plus the absolute address symbol and line number relative address in follow the changes in the formula will be copied to the next. Mixed references part of the address change. Relative reference, absolute reference and mixed references use the address of the cell or range of cells in the formula, the formula is copied to the next, the address is how to change. The specific circumstances of examples: