Protect Sheets or Workbooks

In Microsoft Office, you can use passwords to help prevent other people from opening or modifying your documents, workbooks, and presentations. It’s important to know that if you don’t remember your password Microsoft can’t retrieve your forgotten passwords.


Protect your Excel worksheet

In an open worksheet, click File > Info > Protect Workbook. You see the following options.

protect a workbook

Mark as Final
Make the document read-only.When a worksheet is marked as final, typing, editing commands, and proofing marks are disabled or turned off and the worksheet becomes read-only. The Mark Comment as Final command helps you communicate that you are sharing a completed version of a worksheet. It also helps prevent reviewers or readers from making inadvertent changes to the worksheet.

Encrypt with Password
Set a password for the document.When you select Encrypt with Password, the Encrypt Document dialog box appears. In the Password box, type a password. Important Microsoft can’t retrieve lost or forgotten passwords, so keep a list of your passwords and corresponding file names in a safe place.

Protect Current Sheet
Protect the worksheet and locked cells.By using the Protect Current Sheet feature, you can select password protection and allow or disallow other users to select, format, insert, delete, sort or edit areas of the worksheet.

Protect Workbook Structure
Protect the structure of the worksheet.By using the Protect Workbook Structure feature, you can select password protection and select options to prevent users from changing, moving, deleting important data.

Restrict Permission by People
Install Window Rights Management to restrict permissions.Use a Windows Live ID or a Microsoft Windows account to restrict permissions. You can apply permissions via a template that is used by your organization, or you can add permissions by clicking Restrict Access. To learn more about Information Rights Management see Information Rights Management in Office.

Add a Digital Signature
Add a visible or invisible digital signature.Digital signatures authenticate digital information such as documents, email messages, and macros by using computer cryptography. Digital signatures are created by typing a signature or by using an image of a signature to establish authenticity, integrity, and non-repudiation. See the link at the end of this topic to learn more about digital signatures.To learn about digital signatures, see Digital signatures and certificates.


Lock cells to protect them

Your boss wanted you to protect a workbook, but she also wanted to be able to change a few cells after you were done. So, before you password protected the workbook (or a worksheet), you unlocked some cells. Now your boss is done, so you can lock the cells. Here’s how –

  1. Select the cells you want to lock.
  2. Click Home, then click the Format Cell dialog box launcher (the arrow to the right of Alignment in the ribbon).

format cell

  1. Click the Protection tab, select the Locked check-box, and then click OK.
  2. Click Review > Protect Sheet or Protect Workbook and reapply protection. Notes
    • If you try these steps on a workbook or worksheet you haven’t protected, you’ll see the cells are already locked. That may not make sense at first, but what it means is the cells are ready to be locked when you protect the workbook or worksheet.
    • It’s a best practice to unlock any cells that you may want to change before you protect a worksheet or a workbook, but you can also unlock them after you apply protection. To do that, you remove protection by removing the password.
    • In addition to protecting workbooks and worksheets, you can also and protect formulas.

One thought on “Protect Sheets or Workbooks

  1. Mari

    This is something that useful for me.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment