Microsft Excel 2013: How to easily change to absolute reference
Hi there:
Can anyone tell me how can I change a cell reference to absolute with a simple action?
For example, suppose I have cell C14, and I want to change it to $C$14 without typing the $ sign, by selecting the text C14 and pressing something as CTRL.
Or that when I´m creating a formula, say "=VLOOKUP(", at this moment if I click the cell C14, this reference is automatically typed in the formula, but I´d like to know if there´s a modifier option that makes the text $C$14 appear instead of just C14.
Thanks in advanced,
Rafael
|