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 » Absolute references
Absolute references
Resolved · Low Priority · Version Standard
Tue 19 Feb 2008, 16:05Delegate Ben said...
Ben has attended:
Excel Introduction course
Excel Intermediate course
Absolute references
is the $ sign the only key for creating an absolute reference?
Fri 29 Feb 2008, 14:55Trainer Amanda said...
RE: absolute references
Hi Ben
Thank you for your question.
Yes, any cell reference that has $ signs in front of the column letter and row number is an absolute reference. This is the only way that Excel will understand that the cell needs to remain 'fixed' or 'locked' when the formula you have created is copied to other cells in the spreadsheet.
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:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |
