Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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



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 Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 426
ArviLaanemets 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
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
how to cross reference in word 2013 st_this Word 1 03-20-2014 03:23 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:02 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