Excel Quick Tip: F4 for Absolute Cell References

[@Carla369]

Thanks!! happy to see someone explaining that using the f4 !! I didn't know it and sometimes you have tables with many many cells to modify quickly

[@blackhole99913]

Do I need to hit ctrl + f4? Simply pushing f4 isn't adding the dollar signs

[@skip031890]

If you're using a laptop, then you need to press and hold the "fn" key at the bottom of your keyboard along with F4.

[@georgeelliottphotography3602]

Brilliant thanks. That's exactly what I was looking for. I also didn't know about double-clicking the '+' in the bottom right of the cell would auto-populate the rest. Super, many thanks again.

[@beamaze4977]

Thank you for making it simply and understandable..

[@_askb.]

Thank you!

[@susuvekerekere563]

Thanks for being simple and easy to understand video, especially on relative and absolute cell references.

[@lawrencekazibwe9751]

Thanks Boss, very resourceful

[@devjichawda9091]

Thanks for your information.

[@mikegee902]

Thank you

[@RajSinghPasha1378]

I am pressing f4 but it is not working.

[@winvest9261]

bro teaches the teacher! haha! Good job

[@abyssal8722]

you're a legend tysm!!!!!!

[@seemasharma-ss03rc]

Very well explained this useful tip👍👌

[@DM-kd3yt]

Excellent.

[@HamdanYouTuber]

Thanks for sharing

[@harrytse4239]

thank you, amazing!

[@hanazenabu7778]

I have a name list of an Employee and he got promoted, however the birth date is not the same as before. how can I make excel prevent entering different birth date again?

[@bengelinemetantin8272]

How about here in Philippines?? We used PESO.. PESO SIGN WILL BE USE IN THE FORMULA??

[@aishabagigah7892]

Hello Could you do a video using SAP software?

[@sulemansiddiqui3027]

the F4 on my laptop doesnt work

[@jackiec3919]

theres should be a fn key on your lap top hold that down while pressing the f4 key

[@ashley2705]

Thank you so much for this

[@victoriapierro7283]

@@jackiec3919 THANK YOU SM

[@gradimukwasa1386]

Press the fn key on your keyboard then press F4 it will work

[@HAJSTU]

​@@jackiec3919 Thank you !

[@Journeymane]

Hello sir, how can we schedule one item per day data entry from one excel file to another blank excel file? The source excel file has single column entries only, in Google excel sheet.

[@user-wr9dh6yv1o]

Maybe copy paste?

[@naderthomas690]

I tap F4 and my screen options pop out from the right side of my screen. Is there an alternative way to do this?

[@lucka6576]

Did you find the answer???

[@skip031890]

It depends if you're using a laptop keyboard or a desktop keyboard. Function keys don't work properly on laptop keyboards. You need to be using a desktop keyboard.

[@madhushree8263]

Why is my f4 not working😢

[@skip031890]

Press fn on your keyboard and then F4.

[@slartibartfass5729]

Pretty low salary for your sales people. The janitor gets more...

[@vanjennifer48]

Thank you !