How to Protect a Worksheet in Excel

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).

...
Use a password to protect data and formulas in Excel worksheets.

Step

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

Select "Tools" from the main menu.

Step

Select "Protection" from the drop-down list.

Step

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

Step

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

Step

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.