Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel 2003 vba courses - Absolute references
|
|
|
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 2003 vba courses - Absolute references
Resolved · Low Priority · Version Standard
Reply Wed 24 Oct 2007, 12:50Delegate Jo said...
Jo has attended:
Excel Introduction course
Absolute references
can you explain why we must use absolute formulas in some instances?
For upcoming training course dates see: Pricing & availability
RE: absolute references
Hi Jo
Thank you for your question.
The concept of an absolute reference can be confusing, but it is useful to know how to change a cell into an absolute reference if you need to.
The idea behind this is that if you put together a formula, for example, =A1*B1 (multiples what is in cell A1 by what is in cell B1) the cells in the formula will change when it is copied to another cell in the spreadsheet.
If you need to make Excel keep multiplying by the value in cell B1 when you copied the formula to another cell in the spreadsheet, then you would need to make cell B1 an absolute reference so the formula would look like this =A1*$B$1
This means that if the formula is copied to another cell in the spreadsheet, cell B1 will remain constant or fixed in the formula - it will not change when the formula is copied to another cell.
I hope this helps.
Amanda
|