1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Protect Worksheet Data in Excel Step. 2

Using the Protect Sheet Option in Excel


Protect Excel Worksheet Data

Protect Excel Worksheet Data

© Ted French

Protecting data from change in Excel is a two step process.

  1. Step one involves locking/unlocking specific cells in your spreadsheet.

  2. Step two involves applying the Protect Sheet option. Until step 2 is completed, all data is vulnerable to change.

This tutorial cover step two: Protecting the worksheet.

Protect the Worksheet

By default, all cells in an Excel spreadsheet are locked. This makes it very easy to protect all data in a single worksheet simply by applying the Protect Sheet option.

Unlocking specific cells permits changes to be made to these cells after the protect sheet option has been applied.

Often certain areas of a worksheet are unlocked so that new data can be added. Cells containing formulas, functions, or other important data are kept locked so that once the protect sheet option has been applied, these cells cannot be changed.

Example: Protect a Worksheet in Excel

  1. Open an Excel file to protect. If you open a new file all cells in the worksheet will be protected. If you wish, follow the example in step one to unlock certain cells in a worksheet.

  2. Click on the Home tab.

  3. Choose the Format option on the ribbon to open the drop down list.

  4. Click on Protect Sheet option at the bottom of the list to open the Protect Sheet dialog box.

  5. This dialog box contains a number of options when protecting the worksheet.

  6. The first option is to add a password to prevent worksheet protection from being turned off. This password does not stop users from opening the worksheet and viewing the contents.

  7. Next there a number of options that can be turned on or off with check boxes. The first two allow a user to drag select locked and unlocked cells. If these two are turned off, users will not be able to make any changes to a worksheet - even if it contains unlocked cells.

  8. The remaining options allow users to carry out specific tasks on a protected worksheet, such as formatting cells and sorting data.

  9. These options, however, do not all work the same. For instance, if the format cells option is checked off when a sheet is protected, all cells can be formatted. The sort option, on the other hand, works only on those cells that have been unlocked before the sheet was protected.

  10. When you have selected the appropriate options, click OK.

Turning Off Worksheet Protection

  1. Click on the Home tab.

  2. Choose the Format option on the ribbon to open the drop down list.

  3. Click on Unprotect Sheet option at the bottom of the list.
Related Video
Password Protect Excel Files

©2014 About.com. All rights reserved.