Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - Excel Advanced
Resolved · Low Priority · Version Standard
Artur has attended:
Excel Intermediate course
Excel Advanced course
How and for what $ is used in formulas ?
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
|
|
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
