Microsoft Office Tutorials and References
In Depth Information
Protecting workbooks and worksheets
Click the Protection tab to display the Protection page of the dialog box.
Select the Hidden and Locked check boxes, and then click OK . Excel formats cell B8
so that it won’t display its formula after you protect the worksheet.
On the Review tab, in the Changes group, click Protect Sheet to open the Protect
Sheet dialog box.
In the Password to unprotect sheet box, enter prot300pswd .
Clear the Select locked cells and Select unlocked cells check boxes, and then click
OK . When you do, the Confirm Password dialog box opens.