Jump to content

Lock cells to prevent overwriting


Recommended Posts

Lock cells to prevent overwriting

You can prevent users from overwriting formulas or inadvertently changing labels or formats by protecting those cells. Follow these steps:

1. Select the cells that users will modify during data entry.

2. Go to Format | Cells, deselect the Locked checkbox on the Protection tab, and click OK.

3. Go to Tools | Protection | Protect Sheet, and click OK.

Now users will be able to alter only the cells that are unlocked. If users attempt to alter any other cells, they will receive a message saying they must unprotect the cells to modify them.

In Step 3, you may wish to add a password to prevent unauthorized users from changing a cell's protection level, rather than accepting the default settings.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...