Protect a workbook

To prevent a user from accidentally or deliberately changing, moving, or deleting important data from a sheet or workbook, you can protect certain sheet or workbook elements, with or without a password. You can remove this protection as needed.

 Caution   Passwords in Excel for Mac and Word for Mac have a 15-character limit. You cannot open a workbook or document that has been password protected in the Windows-based version of Excel or Word if the password is longer than fifteen characters. If you want to open the file in Office for Mac, ask the Windows-based author to adjust the password length.Sheet and workbook element protection should not be confused with workbook-level password security. Element protection cannot protect a workbook from users who have malicious intent. For an additional layer of security, you should help protect your whole workbook file by using a password.

Do any of the following:

ShowProtect workbook structure or window size

You can lock the structure of a workbook, which prevents users from adding or deleting sheets or from displaying hidden sheets. You can also prevent users from changing the size or position of sheet windows. Workbook structure and window protection applies to the whole workbook.

  1. On the Review tab, under Protection, click Workbook.

Review tab, Protection group

  1. Do one of the following:
To Do this
Protect the structure of a workbook so that sheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new sheets can't be inserted Select the Protect structure check box.
Protect windows so that they are the same size and in the same position each time the workbook is opened Select the Protect windows check box.
Prevent others from removing workbook protection Type a password and verify it, and then click OK.

 Note   The password is optional. If you do not supply a password, any user can unprotect and change the workbook. If you do enter a password, make sure that you choose a password that is easy to remember, or write it down and keep it in a safe place. If you lose the password, you cannot access the workbook.

ShowProtect and share a workbook

You can protect the shared status of a workbook and stop other users from turning off track changes.

  1. On the Review tab, under Share, click Share Workbook, and then click Protect and Share Workbook.

Review tab, Share group

  1. Select the Sharing with track changes check box.
  2. Type an optional password. If the password field is not active, the workbook is already shared and you must unshare it before assigning a password.
  3. Click OK.

If prompted, save the workbook.

 Note   The password is optional. If you do not supply a password, any user can unprotect and change the workbook. If you do enter a password, make sure that you choose a password that is easy to remember, or write it down and keep it in a safe place. If you lose the password, you cannot access the workbookt.

ShowRemove protection

  1. Open the protected workbook.
  2. Do one of the following:
To remove protection from a Do this
Workbook On the Review tab, under Protection, click Workbook.
Shared workbook On the Review tab, under Share, point to Share Workbook, and then click Unprotect Shared Workbook.
  1. If prompted, type the password for the protected workbook.

If prompted about the effects on other users of removing protection, click Yes.

See also

Protect a sheet

Restrict permission to content in a file

Restricting changes by using read-only status

 
 
Applies to:
Excel for Mac 2011