Moving and coping data

Hi Siobhan

Thank you for your question, and I hope you enjoyed yesterday's course.

Absolute references are used when you want Excel to 'fix' or 'lock' a particular cell into a formula, so that when the formula is copied to other cells, the cell you have made into an absolute reference does not change.

If you search for absolute reference in Excel help, you will find more information on this.

Kind regards
Amanda