Relative vs Absolute Cell Reference in Microsoft Excel - What's the difference?

How to use absolute & relative cell references in Microsoft Excel. Ever wonder what the difference between relative and absolute cell references in Microsoft Excel is? In this video tutorial, I will show why you would want to use each of these. Also, I will show you how to use the F4 key to quickly change through the different cell references.
Link to worksheet: leveragingdigi...

[@wigglebolt4079]

Let me tell you something, that click thing you did 2:35 saved my life, sanity, and health. I have a finance project due and could not get the formula to move down. You are a damn hero sir

[@nsw_27]

Agreed! I never knew that was an option.

[@atilaorlov]

Thank you I took an excel course and the explanation aboute and relative reference was unclear for me. Now I get it. Cheers from México.

[@albertoalamamoran6082]

That´s what I will always say...thanks a lot Jamie keet...as clear as water instructions...GOD BLESS your work. Regards from Trujillo- Perú.

[@TeachersTech]

So happy this could help.

[@gon-rm2lx]

Thanks Jamie! I’m a retired CAD teacher and still enjoy learning things new!

[@cliffordoscar9043]

Despite the economic downturn,I'm so happy☺️. I have been earning $ 60,000 returns from my $7,000 investment every 13days.

[@wallacefelix9548]

The crypto market is highly profitable with an expert broker just like Mr Ray Dalio I got recommended to him and since then my financial life has been a success.

[@darrenerik7605]

I'm a long term investor. I Withdraw my profits of over £56,000 during the covid-19 pandemic

[@abbasahmad6643]

Your explanation is very brilliant.

[@nsw_27]

Very helpful! I am in a CIS 105 course and the examples given were confusing. I needed a real world example to help me understand why I would need to use absolute/relative cell referencing.

[@raminasrallah6598]

Thank you Jamie for your beneficial videos, I appreciate it if you could always put a link to the worksheets for our own practicing.
Many thanks again and have a great day

[@TeachersTech]

You're welcome, there should be a link in the description.

[@raminasrallah6598]

@@TeachersTech Hi Jamie,
I agree for this video and others, there are a links but for some videos there are no links but regardless your help is eternally appreciated.

[@RLWMJW07]

My online class text is so dry. This helped me tremendously!

[@jordankopal1412]

You helped me with my problem on excel, thanks!!

[@lencerlenny674]

This absolutely gave me an answer to my assignment, Would you kindly do a brief video explaining the function of xlookup?
Thank You Jamie.

[@TeachersTech]

I don't yet, but can make it one of my next videos.

[@RodneyKamusiime2004]

Thank you ! Very helpful and informative. Have a blessed life

[@bintwaibuhatwibu4062]

Thanks Mr for ur good work may God make u to leave longer

[@MrJakxon]

Perfect, my Teachers explanation was at best.... rubbish. Thankyou for this, Its all clear now. Plus the F4, sensational.

[@poginglamig1699]

Thank you sir Jamie,
from Phil.

[@akhilepeace139]

Thank you for ease explanation

[@jensuru]

Great, thank you!

[@hadeelhashim5790]

WHAT IF I WANT THIS FORMULAS FOR A ROW RATHER THAN COLUMN, HOW CAN I DO THAT BECAUSE WHEN I DO IT AS A ROW THE FORMULA DOESN'T CHANGE AT ALL

[@farizamin1218]

thank you mr for this! ^^

[@s.haythamalsaid1245]

Thank you so much sir

[@Apollo23682]

Thanks! Appreciate it

[@felixappiah7547]

Wow. I now understand

[@michaelcarterjamaica]

this was so helpful.

[@itsqueencleopatra]

Easy! Thank you!

[@tzoneo8029]

Hello Jamie, thanks for the video. I have been watching your videos for a long time. Thanks for all the videos you put out on varying topics. Some of them have been very beneficial to me. Please, I have an issue with an MS document. The Document is not opening when I click on it. It shows an error message of corrupt file. Can you help me with repair or recovery? It is just one MS word document. It about 608kb, a second version is 900+kb. Thanks.

[@Batman_akzo]

Thank you so much

[@mekaih]

Hi, Jamie fantastic video as always! What does the $ sign do in front of the E in $E2

[@s.haythamalsaid1245]

It locks the E column if you're also working on other columns as F G H

[@TeachersTech]

Exactly!

[@Danny-bbsrSingh]

Nice!

[@thasilabanda3804]

what are auditing features and functional condition features

[@iloveeeroro]

Thank you :)

[@taneenswindell8274]

[@shaherharden9636]

mr. jamie please verify yourself for braves basic attention token, so that i as a viewer can contribute for your content, thanks!

[@aidanrgis7129]

anyone else noticed that the names he used are characters form stranger things?😂

[@maryamashire4731]

Yep

[@Lockit0_0]

Someone else is a Stranger things fan here I see😂

[@safeerahmad3777]

Wow very dangerous

[@user-fl9sz4fp8c]

Kia ye Kisi ny azmaya hy agr yes to pls comment n share your experience

[@user-yp9nz6bs9q]

enter not return

[@user-vp2te5ke6q]

i love you. be my husband.

[@mearkitek3773]

Thanks Jamie! I’m a retired CAD teacher and still enjoy learning things new!