For instance,

I have a finance sheet. And I would calculate the currency rate via this function:


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?


1 Answer 1


The F4 key will do this. See Keyboard shortcuts for Google Sheets

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.