Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - 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. |
microsoft+excel+course - Absolute referencing
Resolved · Low Priority · Version Standard
Reply Wed 5 Dec 2007, 17:04Delegate Suzanne said...
Suzanne has attended:
Excel Intermediate course
Excel Advanced course
Absolute referencing
what is absolute referencing?
For upcoming training course dates see: Pricing & availability
RE: absolute referencing
Hi Suzanne
Absolute reference tells the computer not to increment the column and/or row reference as you fill a range with a formula or you copy and paste the formula.
This is done by using the $ character before the Column and/or Row value of a cell in a formula as shown below:
$A$1 - Both the column and row reference is fixed. Neither will change during a copy or fill.
$A1 - The column reference is fixed. It will not change during a fill or copy, but the row will change.
A$1 - The row reference is fixed. It will not change during a fill or copy, but the column will change.
Hope this explains it
Carlos
|