Password Protecting Parts of an Excel Document

Password Protecting parts of an Excel documentThe last tip I gave you was on how to protect parts of a Microsoft Word document. In this tip, I’m going to show you how to do the same thing in Microsoft Excel.

The example I’ve got open on-screen has got two cell ranges (C12:O17 and C31:034) that we want people to be able to enter content into. The trick is to only allow people to enter content into those cells.

Excel has a feature whereby all cells are Locked when the document is created. You only have to add a Password to prevent people from editing the content. So the first thing you have to do, is un-do that feature.

Setting up for protection…

  1. Select the first set of cells you want people to be able to edit.
  2. Hold down the Control key while you click on additional cells you want people to be able to edit.
  3. Make sure you are on the Home tab.
  4. Click the Format button in the Cells group.
  5. Choose Format Cells at the bottom of the dropdown menu.
  6. Click the Protection tab on the Format Cells dialog box.
  7. Uncheck Locked and click OK.
  8. Wrap it in a password…
  9. Click the Review tab.
  10. Click the Protect Sheet button in the Changes group.
  11. Type a password in the Protect Sheet dialog box.
  12. Make sure that Select locked cells beneath Allow all users of this workbook to: is unchecked.
  13. Click OK.
  14. Re-enter your password in the Confirm Password dialog box and click OK.

That’s it, job complete. You can now select or edit any of the cells you unlocked, but you cannot select any of the other cells.

But what about…

If you for any reason want to go back and edit the other parts of the worksheet, just follow these simple steps.

  1. Click the Review tab.
  2. Click the Unprotect Sheet button in the Changes group.
  3. Enter your password in the dialog box and click OK.

Just remember, if you later want to redistribute your file you will need to re-protect it.

Facebooktwitterlinkedinmail