Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-01-2019, 10:10 AM
rafael.soteldo@gmail.com rafael.soteldo@gmail.com is offline Windows 10 Office 2013
Novice
 
Join Date: Apr 2019
Posts: 3
rafael.soteldo@gmail.com is on a distinguished road
Smile 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  
Old 04-01-2019, 11:03 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,007
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

Select for example C14, press F2, press F4 and press Enter.
  #3  
Old 04-01-2019, 02:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,223
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

This thread is a duplicate of http://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
[MS MVP - Word]
Closed Thread

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


All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft