microsoft+excel+course - Absolute referencing

Hi Suzanne

Absolute reference tells the computer not to increment the column and/or row reference as you fill a range with a formula or you copy and paste the formula.

This is done by using the $ character before the Column and/or Row value of a cell in a formula as shown below:

$A$1 - Both the column and row reference is fixed. Neither will change during a copy or fill.

$A1 - The column reference is fixed. It will not change during a fill or copy, but the row will change.

A$1 - The row reference is fixed. It will not change during a fill or copy, but the column will change.

Hope this explains it

Carlos