I have a finance sheet. And I would calculate the currency rate via this function:
Then, I put the result in
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
$ is really annoying. Is there any hotkey to do this?