FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The F4 key is the easiest way to lock cell references. Simply select the cell or range of cells that you want to lock, then press the F4 key.

Detailed explanation-2: -F4 is a predefined keyboard shortcut in Excel that repeats your last command or action.

Detailed explanation-3: -Many might have wondered, “Where is the F4 key on Excel?” Well, this key is on the first row of the keyboard where we have the function keys. Note that function keys run from F1 to F12. The F4 key is found in between the Excel F3 function key and the Excel F5 function key.

Detailed explanation-4: -Just select the cells you want to lock, then press F4. This will add the ‘$’ symbol to the cell references in the formula, locking the cells in place. For example, if you have a formula in cell A1 that references cell B1, and you press F4, the formula will change to =$A$1+$B$1.

Detailed explanation-5: -Unlock/ lock the Fn key To do this hold the Fn key down (1) and push the ESC key (2). Now you can just press the F4 or F12 button and Excel will immediately do the required action instead of requiring the Fn button pushed first.