Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Excel Advanced
|
|
|
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. |
ms excel training - Excel Advanced
Resolved · Low Priority · Version Standard
Reply Wed 19 Sep 2007, 14:23Delegate Artur said...
Artur has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced
How and for what $ is used in formulas ?
For upcoming training course dates see: Pricing & availability
RE: Excel Advanced
Hi Artur. The dollar symbol is used to turn a cell reference from a relative reference (one which will update to the relative cell position when the formula is moved to another cell) to an absolute reference (e.g. a reference to $A$1 will always remain so, even when moved to another cell). You can switch between the two states by selecting the cell reference in the formula bar and pressing F4.
Hope this helps,
Anthony
|