For instance,
I have a finance sheet. And I would calculate the currency rate via this function:
GOOGLEFINANCE("AUDUSD")
Then, I put the result in A1
.
And then, I need to convert some of my cells to the target currency by *$A1$1
. After I ket the *
key, I can use mouse to select the cell A1
. And then, I have to enter the cell, putting my caret to the place and add two $
signs.
Inputing $
is really annoying. Is there any hotkey to do this?