You can easily lock and unlock specific cells on your sheet by clicking on this button. Make sure that you choose a password that is easy to remember because if you lose the password you wont have access to the protected. You can curb this by adding in front of your row or the column value.
Press F4 on your keyboard.
You can curb this by adding in front of your row or the column value. Most Excel users figure out how to lock these references by either toggling through the options with the F4 key or using the dollar sign symbol in front of the column andor row references. Drag or copy formula and lock the cell value with Kutools for Excel 1. An Absolute Reference can be created by typing a in front of either the row or column of a cell reference.