How to prevent users from changing a formula by locking and protecting cells in Excel

Home > Search > How-to
  by

Follow these steps to prevent users from changing a formula by locking and protecting cells in Excel. By default, the entire sheet will be locked.  We need to remove the lock from the sheet.  Follow these steps to remove the lock from the entire sheet:

  1. Press Ctrl A to select the entire sheet.
  2. Right-click anywhere and select Format Cells.
  3. In the Format Cells dialog box, select the Protect tab.
  4. Remove the check-mark from Locked and select OK.

 

Next, we need to lock the cells we want to protect.  Let's say we only want to protect cell A1.

  1. Right-click on cell A1 and select Format Cells.
  2. In the Format Cells dialog box, select the Protect tab.
  3. Ensure Locked is check-marked.  Select OK.
  4. At the top of Excel, select Review.
  5. Select Protect Sheet.
  6. In the Protect Sheet dialog box, enter a password and click OK.
  7. Reenter the password again and click OK.

Now, when attempting to edit cell A1, a pop-up box appears, warning that cell A1 is protected.



Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments