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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-01-2019, 07:20 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:



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 Im creating a formula, say "=VLOOKUP(", at this moment if I click the cell C14, this reference is automatically typed in the formula, but Id like to know if theres a modifier option that makes the text $C$14 appear instead of just C14.

Thanks in advanced,

Rafael
Reply With Quote
  #2  
Old 04-01-2019, 07:41 AM
ArviLaanemets ArviLaanemets is offline Microsft Excel 2013: How to easily change to absolute reference Windows 8 Microsft Excel 2013: How to easily change to absolute reference Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

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!
Reply With Quote
Reply

Tags
excel 3013, formulas

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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
how to cross reference in word 2013 st_this Word 1 03-20-2014 03:23 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 09:36 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