Video není dostupné.
Omlouváme se.
Excel Relative vs Absolute Cell References
Vložit
- čas přidán 14. 08. 2024
- 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/excelrel... #exceltutorial #excel
After watching several other videos that made absolutely no sense to me, I found yours. Thank goodness! It is easy to understand.
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!
Made simple. Thank you.
Brilliant teaching and easy to understand. Thank you so much.
thank you very much! at the same time an Excel lesson and an English review!
Greetings from Italy 👍 Bye
Instablaster...
So easy! Thanks! I have been struggling 30 years with this.
Thank you! Simple clear and to the point. Well done!
This is so clear and helpful!!! Thank you!
Always helping us, Thank you so much! 🇧🇷
Very helpful. I understand now about why and when to lock columns or rows.
Thank you so much for the fantastic example /explanation!
You have been a Blessing..Thank you
This was a great video. Thank you!
Very well explained.! Thanks..
Excellent explanation!👏
I love this video! This is so helpful. Thank you!
thank you - I understood cell references better because of it! :)
Very useful video
At minute 8:34 you said to tie down the cell you need an * but you meant to say you need a dollar sign
I noted that too.
Thanks a million.
Hi thanks for helping us plzz guide us how to type math formulas like x y and others
Thank you
Another great video. Is the "absolute" formula also called "fix a cell"? Thank you!
Can you teach mixed cell reference as well. Thanks for this vid
Thanks ❤
that really very good
Takako liked the first amount owed to them
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 🙏
Ooops ! 8:38 you say 'asterisk' instead of 'dollar sign'.
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.
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!
Helpful and easy to catching thank you
Give me the $435,000! NOW!!!! Thanks for the video again!
Finally!
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
Do you create excel spread sheets for a fee?
How about here in Philippines.. we used Peso not dollars.