After editing and formatting the worksheet, it may be necessary to share it with other users. While you want other people to have access to your data, you don't want them to accidently change the data or formatting. A way to accomplish this task is to use cell and sheet protection features. You can lock the worksheet with a password, and, at the same time, allow other users to edit relevant cells. In this example, you will protect the worksheet with a password, but allow editing of the salary data in column E. After changing some salary data, you will unprotect the sheet.
To begin protecting the Employees worksheet, it is first necessary to select the cells that will remain unprotected. In this case, the Current Salary column.
To select the Current Salary column (column E),
With the correct cells selected, you can begin to protect the worksheet.
NOTE: The next steps are different for Office in Windows and Office for Mac.
To move to the Home tab, on the Ribbon,
Click the Home tab
To open the Format Cells dialog box, in the Cells group,
Click , Click Format Cells...
To open the Format Cells dialog box, on the Menu bar,
Click Format, Click Cells...
While there are several options on this dialog box, the option needed for this exercise can be accessed by clicking the Protection tab.
To move to the Protection tab,
Click the Protection tab
On the Protection tab, you see that the selected cells (Column E, Salary) are, by default, locked. In fact, all of the cells of the worksheet are locked by default. This dialog box also informs that locking cells has no effect until the worksheet is protected. This means that unlocking the selected cells and then protecting the worksheet will leave only the selected cells unlocked.
To unlock the selected cells,
Click the Locked checkbox
To accept this change,
There is no visible change to the worksheet. It is now necessary to protect the worksheet.
Move to the Review command tab.
To open the Protect Sheet dialog box, in the Changes group,
The Protect Sheet Dialog box opens:
While there are several options here, simply leave the default selections (Protect worksheet and contents of locked cells, Select locked cells and Select unlocked cells) as they are.
Before moving on, set a password to unprotect this sheet.
To set a password,
Click in the Password to unprotect sheet field, type: SalaryReview Enter key
To reenter the password, type:
The dialog boxes close and you are returned to the worksheet.
Now that the sheet is protected, take some time to see how this affects what you can do with the data.
To deselect the Current Salary column (column E),
Click any other cell
To make a change in the Current Salary column,
Click in cell E12, type: 65000 Enter key
The change is accepted. Make another change to a salary.
To make a second change in the Current Salary column,
Click in cell E37, type: 77000 Enter key
Notice that the average calculation in cell N3 changes to reflect the updated salaries.
As expected, data in the Current Salary column can be changed. Now, experiment with changing data in other columns.
To see how the sheet protection works,
Click in cell B23, type: P
As soon as you being to type in a protected cell, a warning appears:
To close this warning,
To attempt to change other data,
Click in cell F15, type: W
Again, as soon as you being to type in a protected cell, the warning appears.
To close this warning,
No changes can be made to the protected areas of this worksheet.
Now that you have experimented with protecting a worksheet, it's time to remove the protection. This can be done in the Review tab of the Ribbon.
To move to the Review tab, if necessary, on the Ribbon,
Click the Review tab
To begin unprotecting the sheet, in the Changes group,
The Unprotect Sheet dialog box appears:
This dialog box prompts you to enter the password created earlier.
To enter the password, type:
SalaryReview Enter key
There is no noticable change to the worksheet, but the protection has been removed.
Take a moment to test that the protection has been removed. Attempt to change someone's last name.
To select the correct cell,
Click in cell B37
To modify the name and verify the protection has been removed, type: