Tuesday, March 24, 2015

gSheets: Absolute and Relative references Toggle (F4)


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.