Microsoft Office Tutorials and References
In Depth Information
After protecting a worksheet, you may find it
difficult to make all the changes that you, its
creator, need to make. To remove worksheet
protection, click the Format button on the
Home tab and select Unprotect Sheet. You can
also click the Unprotect Sheet button on the
Review tab. If you password-protected the sheet,
type your password in the dialog box that
appears and click OK. The worksheet is no
3. To prevent unauthorized users from
unprotecting the sheet, type a password in the
Password box. Passwords are case-sensitive.
4. Click OK.
5. If you entered a password in Step 3, the
Confirm Password dialog box appears and
you’re prompted to confirm the password
by retyping it. Do so and click OK. The
workbook is immediately protected.
Protecting a Workbook
In addition to protecting worksheets from
unauthorized changes, you can protect entire
workbooks as well. When you protect a workbook in
this manner, you protect its structure—prevent-
ing users from adding, deleting, hiding, or
unhiding worksheets. You can also prevent users
from resizing the workbook window. Here’s how:
If you decide at some later date to remove the
workbook protections (the workbook will no
longer be shared, for example), just click the
Protect Workbook button on the Review tab,
enter the password if any, and click OK.
Preventing a Workbook
from Being Opened
When the ultimate protection is needed, you
can add a password to a workbook that prevents
it from being opened by anyone who doesn’t
know the password. Follow these steps:
1. Click the Protect Workbook button on the
Review tab. The Protect Structure and
Windows dialog box appears, as seen in
Set options for the
1. Click the File tab to display Backstage.
2. Select Info from the list on the left to display
the Information options on the right.
3. Click the Protect Workbook button and select
Encrypt With Password from the pop-up
menu. The Encrypt Document dialog box
appears. (See Figure 13-9.)
2. Select the changes you want to prevent:
Structure: Prevents users from adding,
deleting, hiding, or unhiding
Protect your workbook
with a password.
Windows: Prevents users from resizing
the workbook window, although they
can still scroll.