#1
|
|||
|
|||
Microsft Excel 2013: How to easily change to absolute reference
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 |
#2
|
|||
|
|||
Select for example C14, press F2, press F4 and press Enter.
|
#3
|
||||
|
||||
This thread is a duplicate of https://www.msofficeforums.com/excel...-absolute.html - which was answered well before you posted this one.
Kindly don't ask the same question in multiple threads. Thread closed. You may continue the discussion in your other thread.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
excel 2013, formula help |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsft Excel 2013: How to easily change to absolute reference | rafael.soteldo@gmail.com | Excel | 1 | 04-01-2019 07:41 AM |
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 |
Keeping an absolute reference in a cell | bremen22 | Excel | 7 | 01-16-2014 11:06 AM |