Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Absolute Reference
|
|
|
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. |
excel.advanced.course - Absolute Reference
Resolved · Low Priority · Version Standard
Reply Thu 25 Oct 2007, 09:53Delegate Adenike said...
Adenike has attended:
Excel Introduction course
Excel Intermediate course
Absolute Reference
How do Icreate an an absolute renference
For upcoming training course dates see: Pricing & availability
RE: Absolute Reference
Hi Adenike
Thank you for your question.
You can make a cell in a formula into an absolute reference by doing the following:
When you click on a cell to put it into the formula, press the F4 key once immediately afterwards. This will insert two $ signs, one before the column letter and another between the column letter and the row number. This is now an absolute reference which means that if the formula that the cell is in is copied to another location in the spreadsheet, this cell remained fixed or locked into the formula (in other words the cell reference does not change).
I hope this helps.
Amanda
|