Thank you so much, I was struggling to finish my assignment. this video was so helpful. the presentation was simple and easy, anybody can understand, I watched many videos but it was not detailed.
Is there a method for setting absolute cell reference in a range of cells containing formulas? Imagine 2 columns of 100 cells. Column A has random dates. Column B has formulas referencing data in different locations or sheets. The data in column B has to remain with its date in column A when sorted. Is there a way to highlight all the formulas in Column B and change them to absolute cell reference or does each formula need to be changed indiviually. For clarification, the sort can not be done until after both columns and 100 cells are filled. Thank you. Jeff
Hello, I followed every step but I don't think my excel is set up to copy the formula to the rows beneath them. Is there a formatting issue I am missing?
When I try to highlight the $c$16 and paste to the rows below, it says "Alert: the data your posting isn't the same size as your selection. Do you want to paste anyways?"
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
Thank you so much! I have been trying for days how to absolute cell reference for my class. Lifesaver!!
Thank you so much, I was struggling to finish my assignment. this video was so helpful. the presentation was simple and easy, anybody can understand, I watched many videos but it was not detailed.
M also here now because of my assignment
Tomorrow is my computer exam and this is helpful. May you reach 10M Subs!
Absolutely this is my first time,and the presentation is marvelous and quick to understand compare to others I watched before trying this.thanks.
Thank you so much! I’ve missed a few days of school and this was very easy to understand
Very nice presentation and very easy to understand. Thanks a lot. 🙏
This helped SO much for my Computer Science class. Thank you for breaking down each step!!
Exactly what I was looking for. Thank you.
thanks very useful
Thanks. Learned more in a RUclips video than I did on cengage.
Very useful and more helpful❤thanks alot
Very Very Helpful information that is.
Very well explained.Thanks
Thank you
This is helpful, thank you.
Thank you, explained precisely ❤
fn +f4 isn’t working
Amazing Thankyou very much 🥰🥰🥰
Couldn't say any better
F4, that was the button I was looking for. Thanks guys. ☺
this channel is GOATED
Perfect man otherwise everybody just told me first how to use keyboard and then come to main topic
Very nice
Thank you!🙌
thank you
Very useful video 😊😊😊
Thanks a lot! This is really helpful for my studies 🙂❤️
thank you so much
Nice
Thank u luv
exactly a year later, im watching this for a test. thanks, it helped
Thank you🥺🙏🏽
Thank you for this video. this is very helpful.
Thank you ma'am
Is there a method for setting absolute cell reference in a range of cells containing formulas? Imagine 2 columns of 100 cells. Column A has random dates. Column B has formulas referencing data in different locations or sheets. The data in column B has to remain with its date in column A when sorted. Is there a way to highlight all the formulas in Column B and change them to absolute cell reference or does each formula need to be changed indiviually. For clarification, the sort can not be done until after both columns and 100 cells are filled. Thank you. Jeff
Thank you Ma'am for the lesson learned.
Very useful! Thank you.
Thanks this was really helpful thank you
Nicely explained miss thanks for post this video
Glad it was helpful! :)
You save me. 😊 Thank you
Great explanation 👍
Very helpful 🙏🏾
thanks🙏
my f4 locks it but it still drags the same answer down
what do i do
Fn+F4
Hello, I followed every step but I don't think my excel is set up to copy the formula to the rows beneath them. Is there a formatting issue I am missing?
When I try to highlight the $c$16 and paste to the rows below, it says "Alert: the data your posting isn't the same size as your selection. Do you want to paste anyways?"
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
Maam laptop mein kisi kre fixed reference plz tell me
I am using Google Sheets and the formula doesn't transfer to the other cells. 😓 What am I doing wrong.
The teacher I get "Copies from textbook"
The teacher i want-
Super enjoy the lot... love and expect more videos
It's been a pleasure helping you :)
Thanks..well explained..
😌👍👍
Uno Reverse Card
way to long to explain.....
So what? That is great detailed explanation for me!
Thank you Mam
Thank you
thank you