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

F4 toggles through all of possible permutations. But mark this - all references in formula are changed. So in case you need e.g. one reference absolute, and another partial, you are out of luck!