How to Protect a Worksheet in Excel 2007

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.