ms excel training - Creating absolute references

Aisling,

You wan use the F4 key to enter the reference for you.
There are 4 settings - 1 relative, 2 mixed and one absolute.

Simply place your cursor on the cell reference you want to change, and press F4.

Example:
$A$1
Both the column and row reference is fixed. Neither will be incrementd or changed during a copy or fill.

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

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

regards

Richard