How to Protect a Worksheet in Excel 2007

If you created a workbook in Microsoft Excel 2007 that you plan to share with others, you may want to add protection to one of the worksheets. This is useful so you can share a worksheet with others and you won't have to worry about them making undesired changes to it unless you give them the password. It takes little time to add protection to an Excel 2007 worksheet.

Instructions

1. Open the Excel workbook that has the worksheet you want to protect.

2. Click the worksheet you want to protect and then click the "Review" tab located in the Excel ribbon at the top of the page. You can check spelling, add comments, and protect a worksheet here.

3. Look to the "Changes" section of the ribbon and click the "Protect Sheet" button.

4. Enter a password to protect the worksheet. If someone else wants to make changes to the worksheet, they will have to enter the password you selected.

5. Select any elements you want others who have access to the worksheet to be able to change without the password. For example, you can choose to allow other users to edit objects or use the Auto Filter. After you make your selections, click "OK." The worksheet is now protected.

References

• Recipester: Protect a worksheet in Excel