Excel: absolute reference and relative reference

Excel: absolute reference and relative reference


YOUR OBJECTIVE

When copying a formula from one cell to another using the Auto Fill function, you sometimes want a reference to remain unchanged and not be automatically adjusted. With the Auto Fill function, however, the cell references in a formula are automatically adjusted in accord with the position of the new cell. If the automatic adjustment is not suitable for your table, it can lead to an error message or incorrect result. By using an excel absolute reference , however, you can prevent Auto Fill from making such adjustments to cell references. [Read more...]