98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Absolute referencing
excel training courses - Absolute referencing
Resolved · Low Priority · Version Standard
Wed 29 Nov 2006, 16:39Delegate Kate said...
Kate has attended:
Excel Introduction course
Absolute referencing
Is it safest to always put in the dollar signs before every column and row reference or can that sometimes goes wrong?
Wed 29 Nov 2006, 22:14Trainer Amanda said...
RE: Absolute referencing
Hi Kate
Thanks for your question.
You do not need to make every cell in a formula into an absolute reference (the name for a cell that has $ before the column letter and row number), you only need to do this when you need a specific cell in your formula to remain constant/the same in order to get the correct formula result.
Most of the time leaving your formula how it is without making an cells into an absolute reference works fine.
Amanda
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:Bracketed negative numbersOften Excel users wish to display negative numbers in colour red and bracketed |
