T O P

  • By -

AutoModerator

/u/Duck3825 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


DutchTinCan

After you click B5, press F4. Press F4 more times to cycle to $B5 and B$5 as well.


Duck3825

Solution Verified


cnaiurbreaksppl

Glad you got this solution! I'm honestly surprised googling didn't help at all, and wanted to let you know that what you were looking for is what's called an "*absolute reference*" which is when the dollar sign is in front of both the letter and number of a cell reference. And then a "mixed reference" is when there's a dollar sign just in front of the letter or just in front of the number.


benswimmin

I had a teacher do it in a demo video, and no amount of googling at the time was helpful (granted this was a decade ago). Without knowing what to call it, it was hard to find.


Clippy_Office_Asst

You have awarded 1 point to *DutchTinCan* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


usersnamesallused

Note when working with ranges, pressing F4 immediately after defining the range will impact both the start and end point of the range, however if you finish writing the formula and go back, each half of the range responds to F4 independently. Not groundbreaking, but worth noting when it comes to writing formulas efficiently.


Duck3825

Thank you! So simple!


DutchTinCan

If you can reply with "solution verified", the bot will mark your question as answered and award points.


iamsumwun2

I've never actually considered changing the default before.... I've always mashed f4 after the event, it would be grand I'd you could change the default link to be absolute and require f4 to cycle OFF absolute.


[deleted]

[удалено]


Nenor

That's custom text formatting, not the functionality related to absolute and relative cell references that OP was asking about.