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!
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 🙏
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!
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
After watching several other videos that made absolutely no sense to me, I found yours. Thank goodness! It is easy to understand.
Brilliant teaching and easy to understand. Thank you so much.
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.
thank you very much! at the same time an Excel lesson and an English review!
Greetings from Italy 👍 Bye
Instablaster...
Thank you! Simple clear and to the point. Well done!
So easy! Thanks! I have been struggling 30 years with this.
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.
You have been a Blessing..Thank you
Very well explained.! Thanks..
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.
This was a great video. Thank you!
Thank you so much for the fantastic example /explanation!
Excellent explanation!👏
Another great video. Is the "absolute" formula also called "fix a cell"? Thank you!
Thanks a million.
Very useful video
thank you - I understood cell references better because of it! :)
Hi thanks for helping us plzz guide us how to type math formulas like x y and others
I love this video! This is so helpful. Thank you!
Can you teach mixed cell reference as well. Thanks for this vid
Thank you
Thanks ❤
that really very good
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'.
Takako liked the first amount owed to them
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!
Give me the $435,000! NOW!!!! Thanks for the video again!
Do you create excel spread sheets for a fee?
Finally!
Helpful and easy to catching thank you
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
How about here in Philippines.. we used Peso not dollars.