Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 04-01-2019, 07:20 AM is offline Windows 10 Office 2013
Join Date: Apr 2019
Posts: 3 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,

Reply With Quote
Old 04-01-2019, 07:41 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 426
ArviLaanemets will become famous soon enough

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

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. is not affiliated with Microsoft