Protecting Excel worksheet cells against changes


  • If you apply protection to cells in a worksheet, the contents of the cells cannot be changed until the protection is turned off.
  • Locking cells has no effect unless the worksheet itself is protected.
  • By default, when a new worksheet is started all the cells are locked, but the worksheet is not protected, so all cells can be seen as usual.

To protect a range or group of cells in a worksheet using Excel 2007,  Excel 2010 or Microsoft Excel 2013:

  1. Select those cells that you want to unlock.
  2. Click the Home tab, then in the Cells group, click the Format dropdown.
  3. Click Lock Cell. This is a toggle, so will unlock the cells.
  4. Click the Review tab, then in the Changes group, click Protect Sheet.
  5. If you want to ensure that a password is required, type one into the Passwordto unprotect sheet box.
  6. Select what you…

View original post 275 more words


About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s