How to Protect a Worksheet in Excel

By Christy Flora

Microsoft Office Excel is a spreadsheet software that allows the user to create workbooks that analyze information and perform calculations. The data in Excel workbooks, or files, is located in separate worksheets. To protect this data from accidental or intentional changes, you can protect the worksheet. This does not keep individuals from viewing the data, it only keeps changes from being made. When the worksheet is protected, only authorized users can change data, formulas or elements (such as charts or graphs).

Step 1

Open the Excel workbook in which you want to convert and replace the date data with day-of-week data. If this workbook is not available, open up a new file for practice. If using a practice workbook, enter some sample data.

Step 2

Select "Tools" from the main menu.

Step 3

Select "Protection" from the drop-down list.

Step 4

Select "Protect Sheet" from the drop-down menu.

Step 5

Left-click with your mouse in the box labeled "Protect worksheet and contents of locked cells."

Step 6

Enter a password to unprotect the sheet in the "Password to unprotect sheet" field. If you do not enter a password, any user will be able to unprotect the sheet and make changes to the data or formulas.

Tips & Warnings

  • If the information in the worksheet is confidential, it is advisable to protect the entire workbook so that it cannot be opened without the use of a password.