Hi there:

I´d like to know if there´s an easy way change a cell reference to absolute with a keystroke.

For example, suppose I have cell C14, and I want to change it to $C$14 without having to type the $ sign, with some kind of keystroke for example

Or whenever I´m editing a formula, say "=VLOOKUP(", if now I click cell C14, I want the text $C$14 to appear instead of just C14, with a key modifier

Thanks in advance

Rafael