What is cell reference locking? It's when you use dollar signs ($) to signal to Google Sheets that you want to fix, or lock a cell reference. How and when do you need this?
In this video, I give a quick overview of cell reference locking. This is specifically oriented around dragging formulas around the spreadsheet, but has many applications, including conditional formatting, arrayformulas, etc.
On this page of the site you can watch the video online Cell Reference Locking Tutorial - Google Sheets with a duration of hours minute second in good quality, which was uploaded by the user Sheets Ninja 17 February 2021, share the link with friends and acquaintances, this video has already been watched 880 times on youtube and it was liked by 10 viewers. Enjoy your viewing!