Microsoft Office Forums Microsft Excel 2013: How to easily change to absolute reference

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-01-2019, 10:10 AM
rafael.soteldo@gmail.com rafael.soteldo@gmail.com is offline Microsft Excel 2013: How to easily change to absolute reference Windows 10 Microsft Excel 2013: How to easily change to absolute reference Office 2013
Novice
Microsft Excel 2013: How to easily change to absolute reference
 
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:

Id like to know if theres 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 Im 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 Microsft Excel 2013: How to easily change to absolute reference Windows 10 Microsft Excel 2013: How to easily change to absolute reference Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,028
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
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 Microsft Excel 2013: How to easily change to absolute reference Windows 7 64bit Microsft Excel 2013: How to easily change to absolute reference Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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
[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
Microsft Excel 2013: How to easily change to absolute reference 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
Microsft Excel 2013: How to easily change to absolute reference excel absolute reference dschlachter Excel 6 06-16-2015 03:02 PM
Microsft Excel 2013: How to easily change to absolute reference 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 10:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft