Protect Excel Document with a Password

Another technique in formatting worksheet.

You can protect elements (e.g. cells with formulas) on a worksheet from all user access, or you can grant individual users access to the cells you specify. The purpose of this function is to restrict user make changes on your worksheet.

Creating Protection:

1. Tools>Protection>Protect Sheet…

2. Enter password

3. Re-enter password

4. “Allow all users of this worksheet to:”

Example:

When you come to the step 4 mentioned above, unclick “select locked cells” and click “select unlocked cells” allow users to access or modify cells that were unlocked.

A user can lock/unlock a cell by going to:

Format>Cells…>Protection