You often need to lock or fix cells in Excel when in formulas, this video explains how to do that with F4 for absolute referencing, how to check if it worked well & also how to do mixed referencing for partial locking with some more speed-up tips & tricks along the way.

You can download the example files here: https://www.xlconsulting-asia.com/you...

00:00 Introduction
00:52 Show formulas
01:30 Absolute referencing, lock cells with F4
02:59 Rule of thumb for locking cells
04:33 Mixed referencing