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 training - Relative and absoulte referencing
microsoft excel training - Relative and absoulte referencing
Resolved · Low Priority · Version Standard
Louise has attended:
PowerPoint Introduction course
Relative and absoulte referencing
What is the difference between these two types of referencing and what do you have to do to achieve each?
RE: Relative and absoulte referencing
I presume that relative referencing is the normal type of cell referencing when you type, for instance, =A1+B1 in cell C1 and then drag it down column C, this will give =A2+B2 etc.
Absolute referencing is where, no matter how far you drag the formula down, it always looks at the same cell.
to do this, add dollar signs before the reference you want to stick.
for instance, =A1+$B$1 dragged down will then give =A2+$B$1 etc...
Hope this helps
Paul
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:Apply currency format quickly in ExcelTo quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $ |