Changing formula's from relative to absolute addressing by add the $(dollar)sign can be a painful task if you do it manually. Using the Smart toggle feature within gSheets can offer you some relief. (F4)
Example:
[=D4*C4]
Place cursor near D4 in the formule [=|D4*C4] and hit F4.
Repeatedly hitting the F4 key will show you in sequence the following options.
[=D4*C4] , [=$D$4*C4] , [=D$4*C4] , [=$D4*C4] , [=D4*C4].....
The same will happen if you position the cursor near C4
No comments:
Post a Comment
Please be courteous, even if you do not share the same view.