Excel Relative vs Absolute Cell References

Learn the important difference between relative cell references and absolute cell references in Excel. This video explains the distinction as clearly as possible. My entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with this video: bit.ly/excelrelative #exceltutorial #excel

[@ellennorris6484]

After watching several other videos that made absolutely no sense to me, I found yours. Thank goodness! It is easy to understand.

[@amalrajraj8942]

Brilliant teaching and easy to understand. Thank you so much.

[@skiermac4679]

I got a final tomorrow and watched like 5 videos before this. They all made it confusing and complicated. THis was straight forward and simple. Thank you!

[@rilkobholms]

Made simple. Thank you.

[@yagoedesdemona]

thank you very much! at the same time an Excel lesson and an English review! Greetings from Italy 👍 Bye

[@bentonarjun8513]

Instablaster...

[@grxlsshalom5526]

Thank you! Simple clear and to the point. Well done!

[@saozzie]

So easy! Thanks! I have been struggling 30 years with this.

[@ms.t_richardson]

This is so clear and helpful!!! Thank you!

[@ladenise86]

Thank you so much for the fantastic example /explanation!

[@batedordecartas]

Always helping us, Thank you so much! 🇧🇷

[@crystalflores373]

Very helpful. I understand now about why and when to lock columns or rows.

[@amolpathak199]

Very well explained.! Thanks..

[@nepomucenorubymae3680]

I love this video! This is so helpful. Thank you!

[@miracleanyanwu8680]

You have been a Blessing..Thank you

[@kclo2278]

This was a great video. Thank you!

[@saravananganesan1086]

Very useful video

[@isholinda1268]

Excellent explanation!👏

[@suleimanshaik]

Thanks a million.

[@cgr1825]

At minute 8:34 you said to tie down the cell you need an * but you meant to say you need a dollar sign

[@cycleSCUBA]

I noted that too.

[@adeltarakan7978]

that really very good

[@JaxMchunu]

thank you - I understood cell references better because of it! :)

[@simoiyahector-morales3781]

Can you teach mixed cell reference as well. Thanks for this vid

[@AMUDHASUBRAMANIAN]

Thank you

[@hamidghawsi5890]

Hi thanks for helping us plzz guide us how to type math formulas like x y and others

[@deebaxley7800]

Another great video. Is the "absolute" formula also called "fix a cell"? Thank you!

[@aabbe762]

Thanks ❤

[@mazhar939]

Can you do guide videos on LIBRE OFFICE application softwares like (libre office impress,calc,base,writer etc). I think you may consider this comment and make videos on these soon bcz I’m a subscriber of your channel and I liked 👍 most of your videos 😇. Thank you 🙏

[@earthsteward9]

Takako liked the first amount owed to them

[@user-mu2cp2uw9z]

Finally!

[@cycleSCUBA]

Ooops ! 8:38 you say 'asterisk' instead of 'dollar sign'.

[@BTTFF]

Give me the $435,000! NOW!!!! Thanks for the video again!

[@argawshewkena7209]

Helpful and easy to catching thank you

[@newtotry]

Hello is there a way to do relative references with worksheets? Let's say that I want to reference a total in A1 in worksheet May to a carryover total cell A1 in worksheet June. I can make the reference to point to 'May'!A1 in June A1 but when I make a new worksheet July and copy the worksheet from June it stays at 'May'!A1 instead of doing a relative copy of 'June'!A1.

[@chadstechschool8126]

Great question! Unfortunately excel uses sheet references as absolute. There are a couple of workarounds for this, but the easiest would be to show formulas by clicking the formula tab in your ribbon > show formulas in the formula auditing section. Then, use the control + f function to bring open the find and replace tool. Then simply type the old sheet name and replace it with the new. Takes a matter of seconds! VBA would be the other way of accomplishing but much more complex!

[@dwayneseegars1086]

Do you create excel spread sheets for a fee?

[@geneticist1980]

Hi, I hope someone can help me. I have 1536 cells I put reference to different cells but forgot to press F4 to Absolute them. Is there any way I can apply F4 to all of them in one go? Thanks

[@bengelinemetantin8272]

How about here in Philippines.. we used Peso not dollars.