excel training onsite - Excel 2007

Hi Dionne

Thank you for your question.

Relative and absolute references are cell references in a formula.

A relative cell reference changes when a formula is moved or copied to another location in your spreadsheet. By default, cell references in a formula will be relative unless you make them into an absolute reference.

An absolute cell reference does not change when a formula is moved or copied to another location in your spreadsheet. An absolute reference is recognisable in a formula as it has $ signs preceding the column letter and the row number in the cell reference, e.g. $B$4.

I hope this helps.
Amanda
Amanda