Microsoft Office Forums

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:

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 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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 AM.


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