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: -When used with the Alt and Ctrl key, the F4 is often used to close a program or window in a program. Alt + F4 closes the program window currently active in Microsoft Windows. Ctrl + F4 closes the open window or tab in the active window in Microsoft Windows.

Detailed explanation-4: -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-5: -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.