Forum home » Delegate support and help forum » Microsoft Excel Training and help » Setting Up Formulas
|
|
|
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. |
Setting Up Formulas
Resolved · Low Priority · Version 2007
Reply Fri 16 Sep 2011, 12:53Delegate Trish said...
Trish has attended:
Excel Introduction course
Excel Intermediate course
Setting Up Formulas
Please remind me when I use the $ sign whilst setting up a formula?
For upcoming training course dates see: Pricing & availability
RE: Setting Up Formulas
Hello Trish,
When writing a formula you specify cell refs e.g. B1 or C3 etc.. If you copy the formula, the cell reference is relative, meaning it will follow your formula. So if you were to copy your formula across 2 columns, then the cell reference in the formula will also move 2 columns.
Should you not wish this cell ref to move, specify the Dollar $ sign around the cell ref to "lock" it into position.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Sun 25 Sep 2011: Automatically marked as resolved.
|