98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - Absolute referencing
microsoft+excel+course - Absolute referencing
Resolved · Low Priority · Version Standard
Suzanne has attended:
Excel Intermediate course
Excel Advanced course
Absolute referencing
what is absolute referencing?
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
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. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |