#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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!
|
Tags |
excel 3013, formulas |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Does Excel have a way of using variables to easily update reference formulas? | Lluewhyn | Excel | 1 | 10-19-2016 07:59 AM |
Change library reference location | BruceM | Word VBA | 0 | 12-08-2015 12:27 PM |
excel absolute reference | dschlachter | Excel | 6 | 06-16-2015 03:02 PM |
how to cross reference in word 2013 | st_this | Word | 1 | 03-20-2014 03:23 PM |
Keeping an absolute reference in a cell | bremen22 | Excel | 7 | 01-16-2014 11:06 AM |