Excel Relative vs Absolute Cell References

[@ellennorris6484]

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

[@shravang7117]

Thank you so much !!! I have my computer practical exam tomorrow and I had no idea about excel but now I am pretty confident that your video will definately get me good grades 😀

[@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!

[@rilkobhomes]

Made simple. Thank you.

[@amalrajraj8942]

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

[@EnoJohnOffiong-bc9lv]

Thank you very much Sir, you made absolute and relative cell references very easy !

[@saozzie]

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

[@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!

[@crystalflores373]

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

[@ms.t_richardson]

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

[@batedordecartas]

Always helping us, Thank you so much! 🇧🇷

[@kclo2278]

This was a great video. Thank you!

[@isholinda1268]

Excellent explanation!👏

[@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.

[@miracleanyanwu8680]

You have been a Blessing..Thank you

[@ladenise86]

Thank you so much for the fantastic example /explanation!

[@soigne21]

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

[@nepomucenorubymae3680]

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

[@amolpathak199]

Very well explained.! Thanks..

[@cycleSCUBA]

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

[@deebaxley7800]

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

[@hamidghawsi5890]

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

[@simoiyahector-morales3781]

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

[@saravananganesan1086]

Very useful video

[@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!

[@BTTFF]

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

[@dwayneseegars1086]

Do you create excel spread sheets for a fee?

[@suleimanshaik]

Thanks a million.

[@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 🙏

[@aabbe762]

Thanks ❤

[@earthsteward9]

Takako liked the first amount owed to them

[@adeltarakan7978]

that really very good

[@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

[@AMUDHASUBRAMANIAN]

Thank you

[@argawshewkena7209]

Helpful and easy to catching thank you

[@bengelinemetantin8272]

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

[@תמימההרהבית]

Finally!