training microsoft excel - Relative and absolute referencing

Resolved · Low Priority · Version Standard

Relative and absolute referencing

Gilly has attended:
Excel Introduction course

by - delegate Gilly [1 post] (2007 Sep 12 Wed, 14:10) Reply

Could you , in simple terms, explain these two processes

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: relative and absolute referencing

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 10:51) Reply

Hi Gilly. The simplest explanation is that relative referencing does not using the "$" sign, whereas absolute referencing does! A formula using a relative cell reference will, when copied elsewhere, update to refer to the cell which is relative to the position of the cell in which the formula now is. Conversely, a formula which employs an absolute cell reference, won't. The formula stays "looking at" a specific cell range.

A good primer in this is here:

http://techonthenet.com/excel/questions/referencing.php

Hope this helps,

Anthony