Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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. |
Absolute references
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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
|