The steps to unlock all the cells are as follows: So let us see how to unlock all the cells. As we need to lock particular cells in the workbook, it is necessary to unlock all the cells. The cells in excel are protected and locked in excel.
Let us in detail show how are the above steps executed. Lock the cells which contain the formula.Select the cells or the entire columns or rows where you need to apply the formula.Please select all the cells by pressing Ctrl+A and unlock them.
