Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Relative and absolute referencing
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
training microsoft excel - Relative and absolute referencing
Resolved · Low Priority · Version Standard
Reply Wed 12 Sep 2007, 14:10Delegate Gilly said...
Gilly has attended:
Excel Introduction course
Relative and absolute referencing
Could you , in simple terms, explain these two processes
For upcoming training course dates see: Pricing & availability
RE: relative and absolute referencing
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
|