How to Copy a Formula in Excel Without Changing Cell Reference

In this short tutorial, I show how to copy a formula in excel without changing cell references. We do this by pressing F4 on our keyboard to lock a cell reference in place (also called absolute cell reference).
Stay up to date with lessons by subscribing to our FREE newsletter:
www.modernschoolbus.com/free-newsletter/
#shorts #excel #exceltips #exceltutorial.

[@hiozzz]

thank you for the simple and clear explanation. Helped me big time!

[@hk-wv6ux]

I was always correcting formulas manually, it will save me a lot of time and I can easily avoid mistakes. Thank you very much.

[@jmccullum77]

I have spent well over an hour trying to copy a formula from one cell into multiple without changing the range. Your video is the first one of sooooo many that simply helped me. THANK YOU! THANK YOU! THANK YOU!

[@Thegodiva1995]

Thank you so much for this

[@jagadishkumar9652]

Thank you

[@chirichkilipaaripresents]

Thanks❣️❤️

[@pritam876]

Th🎉anks

[@marksibert305]

I want to know how to see a formula from a different cell that's currently being used, but not to use its function?

[@dinukad.kirindage]

👍

[@rohankhaire7963]

I am not able to lock it in my laptop can you share another option for that

[@ModernSchoolBus]

You can type the dollar signs manually and it will work the same way. Otherwise if you are on a mac I think it is Command + T instead of F4 for locking

[@rohankhaire7963]

@@ModernSchoolBus i am using accor laptop and in that f4 option is showing for brightness

[@mollyanne6224]

Speaking so fast. It would be great if you spoke slower so that can make a note of what to do.

[@arthurvanraepenbusch15]

your subscribe button is in the way