Excel 2010 For Dummies
Book image
Explore Book Buy On Amazon

Excel 2010 includes a Protect Workbook command that prevents others from making changes to the layout of the worksheets in a workbook. You can assign a password when you protect an Excel workbook so that only those who know the password can unprotect the workbook and change the structure or layout of the worksheets.

Protecting a workbook does not prevent others from changing the contents of cells. To protect cell contents, you must use the Protect Sheet command button on the Review tab.

Protecting a workbook

Follow these steps to protect an Excel 2010 workbook:

  1. Click the Protect Workbook command button in the Changes group on the Review tab.

    Excel opens the Protect Structure and Windows dialog box, where the Structure check box is selected by default. With the Structure check box selected, Excel won't let anyone mess around with the sheets in the workbook (by deleting them or rearranging them).

    You can protect the structure and windows in a workbook.
    You can protect the structure and windows in a workbook.
  2. (Optional) If you want to protect any windows that you set up, select the Windows check box.

    When selected, this setting keeps the workbook windows in the same size and position each time you open the workbook.

  3. To assign a password that must be supplied before you can remove the protection from the worksheet, type the password in the Password (optional) text box.

  4. Click OK.

    If you typed a password in the Password (optional) text box, Excel opens the Confirm Password dialog box. Re-enter the password in the Reenter Password to Proceed text box exactly as you typed it Step 2, and then click OK.

Unprotecting a workbook

To remove protection from the current workbook, follow these steps:

  1. Click the highlighted Protect Workbook command button in the Changes group on the Review tab.

    The Unprotect Workbook dialog box appears.

  2. If you assigned a password when protecting the workbook, type the password in the Password text box and click OK.

Protecting a shared workbook

If you create a workbook with contents to be updated by several different users on your network, you can use the Protect and Share Workbook command to ensure that Excel tracks all the changes made and that no user can intentionally or inadvertently remove Excel's tracking of changes. Follow these steps:

  1. Click the Protect and Share Workbook command button in the Changes group on the Review tab.

    The Protect Shared Workbook dialog box appears.

  2. Select the Sharing with Track Changes check box.

    Protect a shared workbook so that users cannot remove Excel's tracking of changes.
    Protect a shared workbook so that users cannot remove Excel's tracking of changes.
  3. To assign a password that each user must supply before he or she can open the workbook to make any changes, type a password in the Password (optional) text box and click OK.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: