We need to lock the cell with the formula to calculate the highest sales and protect it from modifications. Our objective is to calculate the total sales for each product separately and then identify the product with the highest sales. Now, let us suppose that we have sales data for several products in different zones. This will prevent the formula cell from any accidental modifications, while all the other cells are open to modifications.
Thus, we will need to unlock all the cells first and then lock the formula cell and then protect the formula. Therefore, it is vital to protect the formula after locking the cell. A locked cell does not guarantee that the underlying formula will be protected from modifications. It is interesting to note that only this particular cell is protected, and no other cell will result in a similar pop up upon modification. If we click on this cell and try to press any keys in order to modify the formula, we will get the following pop up message. This will result in Excel asking for a password when a user tries to access this Excel sheet.Īt this point, Excel will prompt to ask you to re-enter your password just to make sure that there are no mistakes with the password.Īfter this, the cell will be locked, and it will no longer allow any further modifications to be made. It is also possible to provide a password to protect the sheet. This will open up the next dialog box, as shown below. To do this, we will need to navigate to the “Review” tab and click on the “Protect Sheet” option. This will once again open the Format Cells dialog box. Now, we will need to select the cell that contains the formula, i.e. All the cells in the worksheet will then be unlocked. Now under the “ Protection” tab, we will need to untick the “ Locked” option and click OK.
0 kommentar(er)
